For the most part. Nobody who wants to be a manager should, and everyone who could would rather not.

The big drawback to good managers is that they stand up for their teams and don't kiss boot the way bad ones might.