No, there is no stereotypical 'good developer' in terms of their attitude. You can have arrogant developers who are useless, just as you can have arrogant labourers who are useless, and everything in between.
However don't confuse self-confidence with arrogance, a good, competent professional is confident in their abilities and that may come across as arrogance sometimes.
Social skills are important in a workplace. I actually find the best developers to be pretty easy to work with in terms of their ego's, just like any other professional. and the ones with the outrageous ego's to be often cowboys (although possibly they could do a great job if they buckled down and did it). Over here anyway.