The campaign does a good job of capturing the feel of Star Trek episodes, and the story fits well. The resource management is a little one dimensional, and it is generally too easy to turtle, trade well, wait for the enemy to run out of resources (Dilithium) and then crush them. This is one of my all time favorite Star Trek games. I played it for hours when I first came out all those years ago, and can have nearly the same amount of fun all these years latter. The graphics are a bit low poly and dated, but hold up well enough as do the other aspects of the game. My only real complaints are i wish it had a longer campaign, and it can run slow at times even on modern hardware. The game can work in Wine, but seems to be a little picky with hardware/distribution/settings out of the box. I had good luck with getting it to run with Fedora.
The campaign despite being a bit longer than in Armada 1 is less cohesive, and less fun. It would have been nice to have 8472 and cardassian campaigns instead of the Klingon campaign (shortening the 3 other campaigns by 2 or 3 missions would been good trade off to my mind.) The resource management and ship variety improvements are much better than those found in the first Armada game. The AI 'improvements' are a constant source of frustration. The final mission in the Borg campaign is a special sort of hell. The AI has a habit of glitching out in game breaking way forcing you to restart from your last save. It is more annoying and frustrating than difficult. The game can run well using Wine in some instances, but this seems to be hardware/distribution dependent. (It ran on my Fedora Laptop out of the box, but refuses to run on my desktop.)