Hmm...
I'd say Cancer isn't clingy, they just generally care but of the 3 signs they're the most likely to eventually throw down a boundary and walk away. Then later on if said partner is in crises - they'll step up and HELP. Women more so than the men, but it can be both. Why? Because they are the MOM and DADS of the zodiac. They give a **** and usually - not always - have a heart of gold.
Scorpio wants to control, to own, they think they're the smartest, sneaky-iest, and the most likes to be wanted sexually. They're wrong. Then if they encounter a Cancer or any other sign that tries to go - they won't go. They'll turn scary. Maldaptive personalities. Until and or if they're with another Scorpio - then it's perfection. They want to own peoplje. Essp' those that go from booty call to I LOVE YOU.
Pisces - they get hurt and taken advantage and become Jesus in their relationships - they don't cling. They just mistakenly believe that what their "LOVE" says must be true, even when it's totally wrong about them.
I like all 3 signs.