Why my friends always abandon me

It always happens. People come to my life just to be with me for a few weeks or months and then they stop hanging out with me or talking to me. One friend was in very good terms with me, she liked to invite me to her apartment, and she invited me to parties and such, and when I asked her to do something she promised me to do for my birthday because she didn't go to my birthday celebration she ended the friendship because she thought I deserved "a better friend" and that she wasn't mentally well. But now I see Instagram stories of her being happy with a lot of other friends and dating sketchy men.. and I just don't know why she abandoned me and used that excuse to do that. And now I have this other friend I used to hang out with at her apartment who told me she didn't have time to go out and do things like going to the cinema or other things because of family or her job, and now I'm seeing Instagram stories of her hanging out with other friends.

I don't know what I'm doing wrong. This is hurting me a lot and making me feel really bad... Is that because I'm the unluckiest person in the world? Is that because I'm a weirdo and I'm autistic? Is that because I have a very intense personality? What is happening? I feel horrible....

And this is hitting me bad because now I don't have anyone to hang out with most of the time. I feel lonely and miserable. And weekends are miserable because there's no one to do things. I just want to play games, cards, tabletop games, go to the movies, to a park.. with company. But I just don't have company 😭😭😭😭😭 My boyfriend lives 8 hours away from me and my best friends live in Germany and Argentina. Maybe this is because in person I'm insufferable and horrendous. I always repel people, even if they're neurodivergent or autistic. just don't know what to do to solve this and change my situation.