Well, you’ve come to the right place to post about this, because a disproportionate number of people on MN hate other people, so you’ll find a lot of people on here who relate to you. 😉
I spend time with them trying to be more like them and get a bit worn out and do have times of thinking there is something wrong with me.
This jumps out at me. Why would you do this?
There are a wide variety of very different people / personalities at my work place. I don’t expect anyone to be anyone but themselves. If you’re trying to be more like them, you’re never going to fit in / be accepted. Just be yourself. And if they still don’t like you, you haven’t lost anything, and it’s nowhere near as much work for you!
That aside, just leave work people to it. I am very social and love being around my friends. But - I don’t go to work for friendship. So I’m friendly and polite - but that’s it. I get on with my work, and go home at the end of the day. And it works just fine for me!
When I was younger, I did very much socialise with colleagues - I made some lifelong friends, and it’s how I met DH! But not now, at this stage of life. I don’t have time for it, there’s no-one there that I get on with anywhere near as well as my actual friends, so I just compartmentalise that part of my life.
If you are looking to meet people, as others have said, try hobbies or activities, where you at least have a common ground to work from.
But, to reiterate, don’t try to be like anyone else. You’re great just as you are, and if people don’t like you, that’s on them. Onwards and upwards to other, better people.