Amen to all of this. I was a middle-manager for years, and absolutely loathed the leadership aspect of it (although the people in my department were great), despite the fact that everyone around me insisted I was a natural leader.