I'm sorry you are not feeling like you made good friends in the past. But,we people need to have other people as friends. This world can be a hard place to make friends sometimes, and some of us make it seem easy to do.
I am one of those who doesn't make friends as easy, although it might seem like work acquaintances can be friends, and we spend a lot of time there, I think most people don't see work acquaintances as close friends, or make them people they spend time with outside of work.
In my experience most people settle for just getting along well with the people they work with. Not someone who you talk to about deep personal things, or call when you need help. Or other things you would trust a friend with.
Because of that they don't make the kind of alliance a close friend might.
Their getting along with people you don't like is just them getting along well with Co workers. Not a personal insult to you. I believe if you made closer real friends outside of work, it wouldn't bother you.
In my town there is a meet-up group for 'socially awkward' people, I haven't gone to it yet, but, I imagine it might be a good fit for me to meet people like me who aren't as outgoing.
I know that church can be a good place to start connecting with other people.
The trick is to balance out the time and effort you put into the people you do find, so you don't totally focus all your time and attention on one person and overwhelm them with your need to connect. Which we all have that need.
I'm sure you aren't a bad person that other people can't like. You should not tell yourself that, it seems like you have a need to socialize and create connection.
That is totally normal.
Please consider reaching out to other's outside of work, I think you will find it puts the work acquaintances in perspective.