I'm not a good person to be answering a question on romantic love but maybe I can get the ball rolling and someone with more experience will respond.
I'll start by asking you what you found lovable about some of the women in your unrequited love situations. What are you looking for in a woman?