Are you thinking about going into a management position? If so, do it for the right reasons, which should be to coach, elevate others, and be proud of their success.
If you're going to into a management role for other reasons such as a title, money, power, or vanity, then there's a good chance that you'll end up in the same bucket of mediocre managers that you dislike today.