The new age term is "Competence Porn" and man I love it so much.
There's been a resurgence of that in contemporary big budget SF. The Martian. Project Hail Mary. For All Mankind and The Expanse on TV.
Top Gun: Maverick - great class on leading a high performing team.
> Competence Porn
Don’t get me started on their engineering that causes a matter-antimatter runaway reaction if their fuel tanks ever lose power. And routing discharge-prone HV power lines behind the bridge consoles, or placing the bridge on the outer hull.
I love it, and I know this is all in the service of the story, but I will not give Starfleet a pass for that kind of irresponsible engineering.