My suggestion would be that it is the conjunction of Mars and neptune in the 12th that acts as an attractant; you must have an aura of mystery around you, and women would be drawn to a sense of secrets and mysteries that you seem to offer. Cancer would be drawn by their need for emotional closeness and having their needs met by a stronger 'leader' type of person [Aries Sun]: they would be looking to have someone stabilize their own insecurities and instabilities...
Your Moon in Scorpio would also be a big draw for those in search of passion and intensity in their relationship. Your 12th house energies are apt to make you appear rather withdrawn and perhaps mystical which for many is more appealing than the show-off, boastful or overly expressive type of partner.
Here is my formula for determining one's 'relationship chemistry': combine the influences of the Moon, Venus and Mars, and their aspects to each other:
yours is a combination of earth, fire and water
, which ultimately requires a balancing with more Air added in there: as such Geminis, Librans or Aquarius could help to lend the necessary balance for you to be more sociable and outgoing.
Moon in Scorpio [water] shows that your true inner need is to be in emotional control of your own emotions;
despite the fact that you might feel the need on the surface to control others: the question is do you control your emotions, or do they control you, which is a big lesson for the Scorpio energy.
Venus [fire] relates to our ideals and expectations of others: your Venus in Aries would reflect that you would tend to idealize strong, independent women that you might tend to follow, and who likes to engage in physical activity and adventure; you would want someone to inspire you as well.
It can be difficult to balance these differing energies within yourself: fire and water are not always combatible and this can lead to emotional outbursts when things don't go your way. On the other hand, your water can serve to submerge the enthusiasm and inspiration of the partner.
Next, look to Mars in Capricorn: [earth] traditionally expressed as reticent, reserved, cautious, perhaps withdrawn.
If this is not you [counterbalanced by your Scorpio and Aries energies] this would then apt to be the type of women who would be attracted to you...someone more concerned with money and financial stability as well as status.
'I feel like my sun in Aries and moon in Scorpio are always clashing and it's hard for me to interpret why women with certain astrological traits end up floating into my atmosphere.' this is what I mean by
As we see there can be an awkwardness between the needs of your Moon and the values of your Venus:
this can then lead to unrealistic expectations
of what you think
you want, and what you truly need.
And this is where complications can arise in relationships.
I would be curious to know how you would explain the expression of your 12th house energies, which is highly significant yet difficult to define. Your particular generation is born with a specialized mission to perform in your later life, and as such, you need to be learning a lot about harmonization and balancing in preparation.