This is one of the best summaries I have seen. It is also why it feels so similar to parenting: a good manager needs the ability to be the grown-up. This usually involves unfun things like calling out the elephant in the room, letting people air grievances about your decisions in a group, and staying engaged with people even when they're disengaging and pushing you away.
To me, management always felt like it was something that required all my spoons, and it wanted more, no matter how much I gave. I feel this more a lack of fit than something intrinsic to management, though. FWIW I have moderate neuroticism (according to rando Internet surveys). I suspect I'm not good at simply letting things be good enough, and the broadened responsibilities of management present an emotional scaling issue.