Have you tried approaching people who are more "in your league"? One of the important things I've learned since turning 30 is that I need to aim for friends and a bf or gf who are on my level in social ability, economic status, conventional measures of attractiveness, etc. I have autism and I used to believe I could befriend or date the really fun, socially skilled, quirky autistic queers around me. Wrong. I was told by one girl I really liked that our "brains are not compatible" and that made me want to die.
I remember there was another guy I was even more head over heels for who claimed he "loves autistic people," but he hated all my autistic traits, he just liked the people who had autism as an identity or personality type. My stomach is in knots remembering how ashamed I felt for always annoying him without fail. Also, this was before I realized how important looks are to the pretty people and so I didn't know he was way tf out of my league. I did realize it once when he showed a picture of a girl he went on a date with and she looked like a hyper-filtered ig model came to life. I was just like "Oh. OH. Why would he want me?"
Another really embarrassing thing is the fact that I've had really good platonic male friends who are married and their wives trust them with me...because they and their wives are on the upper end of attractiveness and desirability. I didn't realize that was why, I just thought they were really secure in their relationship and trusted me too. When I realized it was because I'm not very attractive and the thought of these cool guys fucking me was like laughable, I wanted to puke.
It's so painful being socially weird and less conventionally attractive. I still have never had a truly long term relationship or a friend group and it's what I want more than anything. However, I do now have two amazing autistic friends who are "on my level" and understand me and accept me. I'm sorta seeing a guy who is much more like me than the guys I've tried desperately to connect with before. I hope I don't scare him off.