I think even that "poor social skills nerd" engineer trope might be partially an example of Berkson's Paradox [1]. You have to have serious technical chops to compensate for a lack of social skills, and it's hard to see all of the people with weak social skills who aren't engineers.

[1] https://en.wikipedia.org/wiki/Berkson%27s_paradox

edit: removing markdown syntax