I've seen good middle management at startups and small businesses where people grew with the company and the place was small enough that reputation and integrity mattered.

At FAANG, good middle managers are the exception, the promotion process incentivizes different behaviors. A manager taking care of their team or, worse, pushing back on their boss isn't playing the right game.