Agree that great managers are sometimes individual contributors who take on the job because they believe doing so is the only way to ensure effectiveness. But it's important to filter for ego-as-motivation, which can make for a terrible manager....

There's another type of great manager, too, whose best quality is their ability to defend the team from b.s. and politics originating elsewhere in the organization. This is especially valuable in large, established companies.