25% of my manager and above in big tech have acted in the ideal way you describe, and the rest have been back stabbing, childish, two faced, toxic, and many other negative traits, making any open honest or direct communication impossible
Honestly, if you've had decent management 25% of the time, you're doing much better than the rest of us.
Management is hard, because it makes significant emotional demands on us, and a lot of people deal with the combination of power and emotions badly.