The best manager I ever had was the best because he simply would leave our team alone. We knew what we had to do and he knew we would do it. He would sometimes ask if we needed anything and things worked great.
Yeah, exactly this. Managers make a huge impact when they're needed, but rarely is that in the day to day. My best managers have always set clear objectives, and moved mountains for our team in the larger organization, but when it comes to executing they've always known it's best to get out of the way (obviously barring situations where things go wrong, or they do need to help).