Stargate built soldiers into first contact from day one. Star Trek kept exploration and combat apart, and the gap showed up hard on a besieged planet called AR-558.

Forget the shaken martinis and exploding gadgets; Starfleet doesn't do well undercover.