Are INTPS socially blind or is it just me?

It feels like in social situations I lack common sense, I'd actually do something stupid because I don't know it's unacceptable.

I’ve realized that I don’t instinctively understand social norms—I have to analyze them. I don’t just “feel” what’s appropriate; I operate on input and pattern recognition

For example, if I want to show appreciation to someone I might say something that'd come off as flirtatious or even a physical gesture that would be inappropriate.

It feels like everyone else got a manual for social interactions, and I have to reverse-engineer it. Even when I figure out the “rules,” I still doubt myself because social norms are inconsistent, full of hidden expectations I don’t always catch.

Has anyone else dealt with this? How do you navigate it without overanalyzing everything or risking misinterpretation?