It should not be surprising that most people have had more bad managers than good ones. Have you ever had a manager that you considered good? What did this manager do that you found good?
Looking back, here are some of the qualities exhibited by good managers I've had:
They were Subject Matter Experts
Showed compassion & empathy and were down to earth
Treated me like a friend
Mentored and encouraged me to push myself
Stood up for me
Provided honest feedback
Allowed me to be autonomous and did not micro-manage
Helped me when I was stuck & amplified my strengths
Treated every individual's failure as a failure of the team as a whole
Publicly praised and privately criticized