If a good leader is somebody who consistently sets a good example, and is willing to sacrifice personally for their team, I don't think there are very many out there. The problem is that companies still need "leaders" the same way TV stations need programming.

If an company decides to invest some money in the pursuit of an opportunity, some managers might get hired or promoted, and the company isn't going to scour the earth for genuinely good leaders. They'll post a job, take a few interviews then promote the person who was going to get it anyway, or hire somebody who looks the part. Generally, one shouldn't take middle-managers seriously.

Managers are what they are, independently from their position on the ladder.

You can have a shitty or wonderful VP, same for the n+5 manager of 2 people down the pyramid. Position rarely defines leadership or setting or not good example.