Star Trek: Away Team

Star Trek: Away Team is a strategy game developed by Reflexive Entertainment and published by Activision in 2001. The gameplay is similar to the Commandos titles, in which you control a small team. Each team member has it's own special abilities, which you need to complete the different missions. The game itself is set after the Dominion War and includes a few cast members from TNG and DS9.

As typical with that genre stealth is more important than firepower. So, you have to do a lot of sneak around and use decoys to confuse the enemy. Most missions have primary and secondary objectives. Only the primary are necessary to complete the missions, but achieving the secondary unlocks/upgrades items. The game also includes a multiplayer mode, in which you can play the entire story with a friend.

Where can I get it?
Like with most other Star Trek games, you can't buy them on GOG or Steam. The best/only option is to go on Ebay or Amazon and buy it from there.

Multiplayer
The game never had any online multiplayer support, but if you use a VPN like Radmin or Zerotier you shouldn't have a problem to play a few coop missions.

Trivia
The hero ship of this game, the USS Incursion, makes a guest appearance in Star Trek: Armada 2 and it's holographic cloaking system is used by the Romulans in Starfleet Command 3.