From my perspective, I've had mostly good managers, in the sense that I've had multiple managers get fired over the years for being more interested in making sure the team had the tools and support that it needed than doing what the org at large wanted that wasn't possible.

To me, the best managers I've had have done a good job balancing what their team was able to do against what the org needed/wanted them to do. Sometimes that was pushing back against the org and doing the hard work of saying things weren't going to happen, and sometimes it was being clear and sympathetic about conveying difficult realities down to the team about what was needed. I've had managers convey things to me that ultimately led to me quitting and finding other work, but I hold them in high esteem because they clearly communicated what needed to be done to meet demands and I decided it wasn't for me and didn't hold it against me.

There are good managers. They're just also good peers who happen to be your manager and fulfill the role of a manager as best they can. Sometimes the system of the company rejects that, but that's also a sign you're maybe working somewhere that wants you to have no peers and no support, and maybe that should prompt some changes for you as an employee.