I have experienced both.

I d argue its not the manager that motivates people that can only be found inbooks. Its the manager that can come in and mend a toxic and dysfunctional team.

The toxic teams end up breaking good managers in the end and they either become part of the problem or leave.

The hero manager described in the phoenix project is a myth.

The motivational one imho is very real but they need a good platform just like everyone else.