First:
> so you'd better be prepared to listen and support them
... is in my opinion basic management 101.
---
Concerning your other points: I do believe that I at least somewhat know how to work with such people (though I never managed such people).
For example, at a former job, I worked under such people; they really liked me, because I was one of the few people who were actually capable of "understanding" their visions and make them understandable to less intelligent (but still smart) colleagues.
I really have a tendency to be liked by frustrated highly-smart people, both because I really love to learn from them and I think I am a decent person to talk to if you are really frustrated (on the other hand, much more "ordinary" people often reproach me for being "unapproachable", "having my head in the clouds", "always being so negative", "complicated to work with", ... :-) ).