My former manager was extremely gifted at salesmanship (selling our "product" to the C level) and was deft at dealing with interdepartmental politics (including posturing to make our product/team more important in the company) for us. But he was a squeezer, and honestly just didn't care about the well being or mental sanity of each of his team members. This made him (in my view) a good or even very-good manager, but far from a great one.
The way most of corporate America is structured today, most managers are incentivized to manage up. That's why great managers are so rare.
In my experience a lot of these managers were essentially failed engineers, they never demonstrated they were at all good at engineering, so no loss like the one above you've seen, and of course they make terrible managers due to poor technical judgement and envy of those who can do it.