Maybe the answer is as simple as to "Join a club."

Maybe thre is a special reason why things go wrong for you.

I think that in general some things can be striped off.

Being ugly. I see many not so good looking people that have strong friendships, sometimes with average looking people, often even with very good looking people. Certainly, people don't match their platonic friendships based on their similar looks.

Stupidity. Ignoring being 'too stupid to make friends', isn't it the intelligent people who have difficulties? Take people with very low iq/mental retardation. Sure, what amounts to friendship for them is not the same as what amounts to friendship for us, but surely they have no problems making friends.
Same is true for people below average but not retarded, and there's a lot of them. Like almost half of everyone you ever meet.

Will you be likely to develop an equal friendship with someone that differs from you 30 iq points? Yes, that is unlikely.

Are you boring?
This is a very good candidate. But maybe more importantly. You appear boring. People go by appearances. People are very shallow regarding strangers. People judge you in a fraction of a second. There's research out on this.
If you 'appear boring to them' or generate 'boring social interactions', they likely won't come back for the same.

When you don't do anything, you won't have anything to talk about. I have often been asked by people trying to strike up conversation "How was your weekend." and I did literally nothing noteworthy for the last 10 weekends. So I started to do some stuff. And I started to lie. As a kid I hated lying. I still hate it. But when I had an eventful weekend, and no one asks and then next week someone does ask, but I had a weekend where nothing happened, I switch them around. And I make a mental note. I can't mess it up. I have to keep track of these lies. If you get sniffed out once, you are done. At least in my mind.

I am 33 now and all my youth I always had that when I was going to say something, people would talk over me. It once got so bad, that I would start over until they stopped to listen. Of course that didn't work, but I was 14 back then. It also always seems to happen to me. Maybe it is my timing.

It still happens today. People always say that when you rarely say something and people respect you, they will listen when you start talking. This is generally not true. But a few times the most social person in the group will notice, take charge, and give you the word. This is amazing to me. I had teenagers do this to me when I see myself as this impressive intense person. I am supposed to have so much life experience, have true physical presense as a tall athletic male. But once in a while, people stasrt talking after you start, I stop out of politeness, and the conversation goes on without me. Until this social person notices. Just one thing I only started noticing age 30.

I used to force myself to social events. Then, when strangers would try to talk with me, I would answer. Then, after the conversation had ended, I realized I had ended it with my answers. Too late.I don't like talking with strangers. I never will. And I show it. They take notice. They interpret: "He doesn't want to talk with me for who I am."

I have and had the same problems. In my mind, I mind-block myself and at crucial points, I take the wrong road or self-sabotage. Then, you start to push people away. In the end, it is a numbers game. So if normal people needs 100 attempts for 1 success and does those in a month, and it takes me 10 years to get to 5 attempts, it fails.

No one can speak for your life. You have to write down stuff in a lot of detail. But then people won't read your posts. And then they can still only guess and interpret their interpretation of your version of the truth.