Or perhaps it's because a lot of people who are really good at code are really bad at people?

"Best" is pretty subjective. If you can create great code but piss off your fellow developers and managers, expect to be booted. Except that these kinds of people will never understand that they're the problem. 🤷‍♂️