I have the same thought when I see presidential campaigns. I don't think a balanced person would put themselves and their families through that. You have to be some kind of crazy to do this. Maybe we need these extreme people, but I am not sure we should take them as something to aspire to.
That's an interesting point about Henry Worsley - he was clearly an excellent leader but he couldn't rise in the UK military (and I suspect this is the case with many organisations) because above a certain point the job is about politics rather than leadership.