Take the Challenge of the YMMV Tropes to determine your destiny!
Awesome Music: The game actually manages to have better music than a lot of contemporary Star Trek episodes. Stand-outs include the theme played when Kavok beams aboard the Enterprise and hijacks the ship, and the Jaws-like theme that slowly builds up in intensity as the Enterprise approaches the Klingon homeworld during the final five or so minutes of the game.
Colbert Bump: While it was already one of the most well-known VCR games thanks to its association with the Star Trek franchise, Spoony's using footage from the tape for his "Experience Bij" segments helped propel it back into internet consciousness.
Hilarious in Hindsight: The stardate given in Riker's voiceover at the start places the game about a year-and-a-half after the show's finale. By which time the Enterprise-D had already been destroyed for about a year, and the peace between the Federation and Klingons had collapsed on its own. In fact, the latter unwittingly helps explain why the Enterprise gets attacked the minute it shows up at the Klingon homeworld, somewhere it had already visited at least twice in the series proper without being fired on.