If you're going to do a direct comparison, Moon/Moon is better than Sun/Sun. Moon is the emotional center, and more important for romantic relationships. An Aquarius sun man with water ascendent/water moon + water venus could potentially be a good match for a Cancer sun woman.

I'm a Cancer sun/moon but 20-22 degrees (weaker effect). My Leo rising is 6 degrees, so I hit as a Leo unless I'm super vulnerable with you or having a rough day. If you have a Leo Rising, your descendent (who you instinctively attract) is Aquarius... and sweet baby Jesus do I attract a lot of Aquarius sun and ascendent men.

My last two exes were Aquarius ascendent, and I'm going out on a 2nd date with a 7yr younger Aquarius lawyer on Thursday. I don't follow the formula at all of being emotionally restrained, upbeat yet aloof. I am super wild and passionate, and on our first date, took him to an arcade, kicked his ass at shooters, then got super drunk and started sobbing in his arms at the end of the night over my recent ex, then went home and didn't text him for 2 days. He was desperate for a 2nd date lmaooo.