I think people are over complicating this. The real answer is:
Just look for women who like intellectual, serious, unconventional men.
Be careful talking about "majorities." Doing so robs people of their individuality.
You said you had no problem having women as friends... so it sounds like women DO like you. They enjoy your company and like what you have to offer. Maybe your problem is not knowing how to make things sexual/romantic. Hell, maybe your only "problem" was just missing these friends' signals that they would have been interested in more.