I have worked for a few different companies and various teams within them and on the whole, I would say you get more bad managers than good managers in terms of line managing and actually being able to do the people management part of the job well (development, criticism when needed) and remain professional?
I have had managers / directors who either get too friendly and want to be liked and then struggle to be tough when needed or a total nightmare and their personal mood / happiness dictates the whole team culture.