Good managers are hard to find! Partly because a good manager will take risks. Nobody wants to take risks because they're unable to defend that decision in the face of challenge from further up the chain. The decision itself, whether right or wrong, is what defines a leader, the willingness to make a call and see it through.
Good managers are also rare because I believe there's a serious lack of definition for what that word means, what it entails. I don't have all the answers, but I do know what they're teaching kids at University certainly isn't anything a good manager needs to do. They're not teaching risk management, they're teaching risk avoidance and that's probably the least useful thing a manager could possibly do.
In my own career, and now my own business and inside my organization, I consider effective managers to be enablers for their staff. I define the strategy and it's up to my managers to design the tactics that see that strategy realized. The manager is there to provide general guidance, but most importantly they're there to remove barriers that are hindering their staff.
I don't accept reasons for why things can't be done, they have to be done. But I'll gladly listen to my managers tell me what their staff need to get those things done. It's not my place to figure out how to do something, that's the managers job, and I, as the chief manager, remove barriers for my managers. It all works nicely.
It's also why I don't normally put the most technically gifted people in organizational management roles. I believe good managers should be competent in their field of responsibility, but I don't want them thinking tactically, which is what technically excellent people automatically do. I want manager who creates and enables strategies within their departments and have the technically superior staff tell him what they need.
Good managers don't need to 'motivate' or 'drive' their staff, they need to enable them and take risks when necessary. Lead the entire team forward, not hold them in place with risk avoidance.