Good management is almost certainly situation specific. Such that for a good manager, you also need a good organization. And for that organization, you likely need a certain kind of worker.
Tech work is an odd one as we can't decide if we are general contractors, artists, or line workers. Each will have different quirks on how they work. And, annoyingly, all could probably work at any given task. Especially if the full team and organization is aligned with those quirks.