I've had a few really good managers over the years and in all cases I wouldn't have wanted their jobs - yes they had power over me, but they always communicated clearly and asked for my input when appropriate, set clear goals and (most importantly) acted as a political shield while the rest of us were doing our jobs of getting stuff done.

Mind you - have had awful managers as well - but fortunately not very many and not for a long time.

Edit: I should also add that I've certainly been an awful manager at times....