However, my ability to tap into the social zeitgeist is pretty close to zero.
The end result is that I get along fantastically with most people because I can anticipate what they want. But I get along terribly with people who want me to fit in with the social rules that they are playing by. What they want is for me to act normal. And I don't know what that is.
It manifests very similar to what you're describing. After a relatively short period of time certain people get very tuned off by me and they become easily frustrated by my actions.
My theory is that they're diligently playing by the social rules and then I come in, break all of the rules right in front of them, and then I get a mostly positive reception because it's what most of the room wanted anyway (just done in kind of a funny way).
I don't really have a solution.
[At least for me things get really interesting whenever I interact with sales people. As far as I can tell like 90% of that profession runs on everyone following the appropriate social scripts. I barely understand them so thus far I've not encountered a sales tactic that actually works on me. Occasionally they get really desperate as their best plays get met with awkward silence or declining their bad deal. The flip side is that they don't understand me either so asking for what I want doesn't seem to work. I just have to hope I'm able to find something that makes do. ]