I've had a similar experience. Throughout my twenties, I made active attempts at establishing friendships, but failed miserably. I reached out to old classmates via Facebook when I was 23, only for them to keep me hanging on for a year and put no effort in meeting up. At work, at the monthly autistic circle, at festivals, excursions, and Meetup groups, I met a lot of people, but ultimately none of them were interested in pursuing a long term friendship with me. I had to conclude that I am simply universally incompatible. I had to find peace with this. What pulls me through is my will to survive, my interest in the world around me, and my new-found love for myself. Why should I care about all these other people who don't appreciate me? I like myself and I have the right to be in this world, and I don't have to feel miserable about being on my own.
PS: Evangelion is my favourite anime, although my fav character is not Shinji but Rei. She is a unique person even within the context of the show and starts out as pretty oblivious to all social things. Yet she ends up being a key character in the conclusion of the story. She finds a place for herself unrelated to Gendo's expectations of her.
_________________
clarity of thought before rashness of action