It's not unusual. To be honest when I talk to people unless I wear the mask that answers the expectations as I've cracked some social codes throught the years... There's no way I'd be interesting anyone. I don't mean anyone at all, I mean very very very few people, unless others are interested by using something I know or share a similar way of relating to the world (doesn't often happen). It's the same since primary school to be honest. Not knowing how to "play" and "enjoy" and "relate" to others while it's about games and indistinct social untold rules, not able to spend time with an other because it just ended up silent (don't know what to say/do). But I had suddenly friends inside the classroom because I could explain stuffs we were doing and usually (not all the time) was faster. Outside of the classroom, I'm no interesting unless I put the mask of what I know people like, become somewhat funny and enthousiast about things that don't interest me at all.
To make friends, to be honest you have to make yourself interesting and be interested in things in them that you don't believe are interesting. At least that's what I learned, I'm not saying it's THE truth, but that's how I deal with that. Learn about subjects that interest others, manufacture a point of view about those subjects, and try to have a "back and forth conversation" and notice what the other one's personality is like - it's not like yours. But yes it's tiring and it asks a lot of learning and observation about human behaviour. It's not natural to me.
Having reliable people around you who can explain to you a situation or even warn you about something is important, at least it was very important when I was younger. I made a lot of mistakes I didn't understand (when learning to mask and do what NT people would, for example I learned to look at people in the eyes and smile when meeting them, but as I'm a woman it was frequently happening that men thought I was flirting while I wasn't, and then they started flirting with me and I wasn't because I didn't understand what it meant socially. I had difficulties understanding that they were flirting until being trapped and the situation being already difficult to get out of. That's an example, I have plenty of stuffs I had to manage to go backwards because of learning to appear as "being open - enjoyable", but not understanding the social situations that follows!).
Difficulty with social codes coupled with my determination to "be normal" and "make friends" and "have relationships with people" has put me into a high number of weird situations because althrough I was playing as if I was the same, I still didn't get other people and what they were doing at all. To be honest, what I'm lacking was even bigger than anything I could've imagine was actually going on. I'm sure it's still the case.
I was trying to be nice and socialize "correctly" but was completely clueless about what happened around me.
I have a safety rule, that's not to trust anything people say unless they FACTUALLY were reliable many times in the past. If they were unreliable, I trust that they are unreliable, not what they're saying. I used to trust what people say too easily. Now, I rely on facts and my own judgement, I make no excuses unless I am willing to (I never feel forced anymore), that's my safety rule. I won't trust anyone I don't know to be reliable, and I won't trust anyone who has proven himself/herself to not be reliable. I don't trust what other people tell me about their feelings. I trust their actions, the facts that prove their feelings or invalidate them. Throwing a glass of water in my face because you love me isn't love. Sorry. Fact comes first, always, not the justification of a bad action. That's an other thing I understood too litterally my entire life, "there's something between us" (and other expressions referring to that). No, there's not. There's how I relate to you and to the world, and there's how you relate to me and to the world. It's not mutual nor reciprocical, there's no equal feeling "between" two people. I didn't even realize that I understood this saying litterally, but I based my relationships, even friendships, on something that might be between us. But it's a metaphor, it doesn't actually exist. It was confusing my social understanding a lot !!! I thought I had to work on maintaining a link that actually doesn't exist. There is the way I relate to an other person and the way the other person relates to me through. But taking the metaphor of a "link" too litterally was making me misunderstand social codes/actions a lot. I don't know what else I'm doing/thinking upon a too litteral understanding of things that don't exist to be honest. Certainly plenty.
I don't yield to tantrums, intimidation, and so on. An other thing I didn't understand about social codes. Althrough I can feel bad about something because I honestly do, other people... play. Yup. Couldn't believe it. It was everywhere in movies, TV shows, anime, warnings in children's stories but I was super blind to it. It helps me now to avoid assuming anything about other people - accepting that we're really different and I can't understand them.
Whenever I make the assumption that I understand an other person, I'm wrong. That was also impairing my ability to understand social codes : I thought at some point that I did understand more or less. Lol. I don't.
That's the main issue I have with social codes, my own safety. Isolation is secondary now.