Star Trek TNG as a whole was a masterclass on how to effectively manage a high performance team. It's a favorite watch in tech leadership circles for this reason. Every now and then I re-watch this clip of Data taking over the enterprise and the inevitable hiccups he runs into [1].
Really high quality writing for its time.
[1] https://www.youtube.com/watch?v=nlnZKTXKidU