I dunno. I don't really feel like the character of Star Trek fits within the typical combat game template.
The whole point of the franchise is exploration, finding out what's out there, and expanding the realm of the possible. If I'm in charge of a Starfleet starship, I fully expect some number of my encounters to be techtech'd away or for many of the challenges to be moral rather than tactical.
The enterprise no bloody a b c or d was in constant peril, but the enterprise d was only very rarely in a situation they couldn't shoot their way out of.
Literally in every series except Voyager the Federation is in a hot war with some foreign power and the "Remember when we were just explorers?" Lines are usually tongue in cheek, with the full understanding that exploration was only ever a small part of Starfleet/Federation operations, while they spent far more time dealing with rogue factions and warring with other species.
agreed, the Enterprise always stops the warp engine in front of another ship's debris. Ton of stories about manouvers with pilot names, tons of situations where the ship weapons doesn't work so they have to resort to diplomacy, and we've always looked at this world from the perspective of one ship. I'm pretty sure the rest of the captains are more Jellico than Picard