Dear OP. You sound smart and, in many ways, appealing. I am the "nice Jewish boy" type and have been shocked at how many women like you have approached me on dating apps. Also some other people of color from high pressure families, including Nigerians and Latinas who grew up with successful parents. Your experiences are not as unusual as you think.
Two books you might like are I Hate You, Don't Leave Me (about borderline personality disorder) and Permission to Come Home (Asian American perspective on various psychological issues).
I'd also try Bumble for friends. Many smart, straight, lonely women are finding great friends that way.
There definitely is hope for you. But you need to work on your thought processes as others have said. No platonic friend or lover is going to retrain your brain. You need to do that with professional help.