People are great to work with when the work just "flows" around them. Their personalities are (mostly) orthogonal with that. It doesn't make them assholes. Come to think of it, the assholes are more likely to smile. YMMV.
Generally, yes.
It's human nature to be judgmental. You can disagree with it all you'd like, but ignoring it will directly impact you in a negative way.
It's why I try to go out of my way to smile and ask someone about themselves every time they come by to ask me a question / chat / whatever, even if I don't feel like it.
Such positioning may seem fake, but I feel it's "fake" in the same way wearing clothes is "fake". You can disagree with wearing clothes, but running around without pants won't win you much respect.
The OP was about being indispensable; and as I said, the person who is indispensable is the one the business can least afford to lose. There are occasionally other considerations, but they are all done without reference to most of the items on that list, at least from what I have seen.
No, but I would prefer not to work with a douche-bag.
However, if you're only referring to the strict subset of traits that make you a good programmer (and nothing else), then yes I agree.