I skimmed the comments and didn't see the following perspective so thought I would add it: one thing that makes it great for me to work with people with deep expertise is the ability to learn amazing things. I am willing to put up with a lot of 'management personality/quirks' if it comes with learning that is invaluable. I believe people who work with 'interesting' (sometimes abusive) chefs such as Gordon Ramsay may also share this motivation. However, this is just my opinion and I can't say that there is a general trend for this sort of thinking.
Nothing more annoying than an incompetent co-worker or boss. I don't think you're alone in that regard. If someone is competent that means I can trust them to do the right thing. If they're incompetent it's a crapshoot and causes unnecessary stress. I guess that is not necessarily the same as deep expertise but it's hard to imagine someone with expertise who is also incompetent in that domain.
I based my comment on my personal experiences and also from reading Ramsay's biography. I have also read some anecdotes from people who worked with Jobs.
Ramsay's temper and abusiveness are legendary but people who work for him tend to stay with him for a long while; probably no correlation to subsequent success, I admit. That was the crux of my comment: the trade-off of putting up with a lot of quirks vs. learning things that you cannot learn anywhere else. Some people find the learning experience overrides the quirks to a certain point of personal tolerance.
Yes, just because a boss is expert doesn't mean they're innovative. The best bosses, IMO, know the state of the art, the state of the practice (both cutting edge AND reliable), and place a high value on invention and creativity, esp. toward improving on the status quo. Support for learning and exploring AS PART OF THE JOB is central to that zeitgeist.
