I was lucky that my first technical role was where I found the best manager I've had. He was my 2nd supervisor in that first role.

After that I got to be pickier than most about where to go next, so my results might be rosier than others. In total I've had 7 "supervisors" in my technical career. 2 of them were amazing and I would take a (small) pay cut right now to work with either. 2 were good, mostly hands off, and easy to work with. The other 3 were nice people with good intentions, but significant managerial shortcomings. None of them were bad or insufferable.

In one case, an extraordinary mentor almost entirely made up for shortcomings of the manager. Working with great people alongside you often makes the incompetency of the people above a little less relevant, or at least more tolerable.