I see a certain tenderness in men with Cancer energy. It's a particular masculine tenderness. And it's very appealing to me (straight female). I'm actually not attracted to men who don't show some version of it.
More of the people I've dated, or even had crushes on, have been Cancers than any other sun sign. Although Cancer placements aren't the only way to manifest that energy. My longest-lasting relationship was with a man who has no Cancer placements at all, but he has Taurus rising and a first house Taurus moon, which creates a similar energy.
My DC is in Cancer, so being attracted to people with Cancerian traits is natural. And not just romantically. Lots of people in my life, more than just random probability would account for, have significant Cancer placements. My dad is a double Cancer (sun and moon). Among my friends, if I know their natal chart, Cancer placements are included more often than not. If it's not their sun sign, it's their moon sign or rising sign or a sign with strong planetary presence.
Long story short, there are women who are very attracted to men with Cancer energy. I'm one of them.