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…
I agree with you that I want to work with/for those sorts of people. I disagree that I want them as my boss.
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.