Really good manager is highly context dependent. I had a manager early in the pandemic who was reasonably effective, but only because he was everywhere and picking up stuff via overhearing convos in our corner. It worked because he was omnipresent.

As soon as communication and the flow of information needed to be deliberate, he was more challenged.

In person, anything he wasn't present for never got considered or failed.