Difficult to reply with anything that doesnt sound like a total cliche. You just need to find the right one, you need to go out more, stop feeling like that and change your perspective of yourself and stop identifying yourself with passing emotions. Its all true but I guess kinda recycled. I dunno, maybe I can add that we've all been there at some point. And that these women that chose the as+holes are only worth forgetting. Why even waste time thinking about them man. Being "emotional", you say it like its a bad thing. This machismo of today, shoved into out minds through movies and other BS is just that, BS. Be happy youre not a one dimensional prick.
Also so so much of this culture today makes us feel like we are half of a whole and need a partner to be whole. That is usually an equation for not a very balanced relationship. It can be durable but its very conditioned on being with someone. I just dont believe in that. And this craving of yours for a relationship and intimacy is completely normal and a response to you being currently lonely. The more depressed and lonely the more you will wish for a woman. But the problem is, once you get her and this big hole is filled, youre still filling a hole. It wont be healthy. Youll be dependant on her being there. If she leaves you aka crawls out of this symbolic hole, it will be there again. And you depressed. You need to realize youre a whole person by yourself otherwise youll be in this limbo without any control for the rest of your life. It sux being dependant on anything, a woman or a drug.
And these meds youre talking about would be a lot like being on opiates. When I was at my worst my libido was at zero, months without any wish for anything sexual. Makes you realize how much of it is actual chemistry of the brain. But it also makes you reconsider what is actually a good relationship. Each guy knows how drastically you mindset changes once you orgasm. It can be like day and night with regards to a woman. But your libido is a hell of a lot also connected with motivation in general, mind sound lame, but it does feel a bit like a life force. When I had my at zero, man I was lazy and unmotivated.
One reason why girls might not like you as you claim, is that they feel the need from you. That can be very obvious. I bet at least some girl in your life was throwing herself at you at some point in the past and you know how unpleasant that can be. Its another cliche in life but its so true, usually the less you crave something the more it becomes available to you. The less serious my approach to women and relationships was, the more women liked me and wanted to hang out. Which makes in the end a lot more balanced relationship, approaching someone with a lot of neediness correlates a lot with preconcieved notions of what it should be like, what you want, your portrayal of it, your wishes. A lot of sh't put on a lot of nothing (yet). Youre a whole by yourself. If you approach a woman like that, first, she'll dig you a hell of a lot more because the back and forth will be a lot more playful and easy without all the heaviness of your expectations and will have a lot more potential to grow into something more.
Easier said than done I know. But it starts with you getting this silly idea about castrating yourself out of you head right now. It might seem like a curse now but It will be so much fun once you can use it the way its intended. It only seems like a curse because you have no control over yourself, your mind and have this fixed expectations. I know how difficult it is to change all that but you need to take a step back and start appreciating yourself as a person and stop seeking your self worth through other people. Women feel that instantly. When you go out, instead of torturing your self with fear when talking to a girl, just trying seeing the bigger picture, two people trying to see if they like each other. Not you seeking approval and her to make you happy. No, no expectations, youre not a seer, dont make women out to be this saviour for your loneliness and depression. Step back, your seeing whether youre even compatible and have sth in common and her doing the same thing, dont forget shes lonely too and looking for someone. Dont idealize how perfect she seems and how much you like her already. Relax, remember youre worth exactly as much as her, its equal footing and that you must not succumb to this cravings of yours to be in a relationship and how it will make you happy. Keep realizing, its your mind playing tricks on you and that its you without any control which will lead into nothing but an unhealthy relationship.
(for a few techniques I suggest reading sth buddhism related like by Lama Yeshe,Ajah Sumedho,Ajah Chah,..., different approaches,see what you prefer)