well, i have a cancer sun, a scorpio moon and a pisces ASC
on the surface i can be light, fluffy and flirty, however, in close personal relationships i seek out depth.
i was married for over a decade to a man who has a cancer sun, scorpio moon and cancer ASC. my emotional needs were met at first. i never felt jealous, obsessive, or needy with him. quite the contrary. he has/had addiction issues which ultimately turned into a big deal breaker.
after that, i was in a relationship with an aries sun, capricorn moon and gemini rising. this was a rebound relationship and quite a disastrous one. i wasn't emotionally available myself, so can't really comment on his availability. i think he was also quite wrapped up in his own issues but he wasn't emotionally cold and detached.
then i had a short fling with a gemini sun, aqua moon (conjunct my NN), scorpio rising, who at first sight appeared 'deep' to me (scorpio rising) but was all air and very cold and detached. i even nicknamed him 'the iceberg'.
then there was an aqua sun (conjunct my NN), libra moon, unknown ASC (possibly scorpio. he refused to give me his birth date and it took me a lot of time and effort to eventually find out when he was born) i had a lot of contact with over an extended period of time. nothing ever materialised as this was an 'internet' thing. how uranian. i was, however, quite interested in him, but whenever i asked him anything personal, he would withdraw. yeah. not for me.
and the last one was a cappie sun, venus/jupiter/moon in aqua (conjunct my NN) and libra rising. he had no water in his chart, other than saturn in cancer. this one really took me by surprise. i think it was his libra rising that fooled me into thinking he was 'deep'. he was the opposite of the usual alpha male type i seem to attract. he was very sweet, kind, gentle, soft spoken, all about fairness and equality and he talked about his 'feelings'. too bad he projected his unresolved feelings for his ex wife onto me, which i took as genuine. perhaps they were, they were just not for me
when he started to realise he was not over his ex yet, he completely withdrew and became very cold and detached towards me. i have never felt so rejected and ignored. nevermind confused. now that i've been processing things, i am starting to realise he was never 'deep' at all and the special 'connection' i felt, was just based on words (i am a sucker for words.... venus in gemini). i fooled myself. ouch.
you were married to a sag sun, gemini moon? i really don't get that at all, when looking at your chart but you already mentioned this wasn't a fulfilling relationship. i'd prefer to see an earthy moon over an airy one if i were you.
the other ones all have significant water placements. i really do think a cancer sun or moon is a good match for you. pisces, too but i think cancer is generally better at giving you that sense of security your moon seems to need.
i can understand the pisces attraction as it trines your scorpio stellium, though aries is a mystery to me.