At my current company, I've had two managers in the 10 months I've been there. Neither of them has directly been a big part of my employee experience, which has been great and is certainly to their (and the company leadership's) credit.
As a developer in a scrum team in a scaled agile organization, my team gets technical guidance from a software architect, organizational guidance from a scrum master, and the purpose of our work is to support the product for which we get guidance from a product owner. So there isn't as much left over for our boss, who checks in on us regularly to listen to our concerns. It's certainly less stressful that the people who tell us what to do have no direct power over us, and that they trust us to figure out how to get things done.
Of course the real test comes from how they handle problems when things go wrong, but it's been a good 10 months so far.