I really enjoyed Starfleet Academy on SNES. But my favorite games were the Star Trek: Starfleet Command games on PC, especially Starfleet Command Orion Pirates.
The perspective is interesting and enlightening. For me, TNG was MY Star Trek. The first episode aired when I was 5 years old and I watched every episode with my dad over the seven year run.
All these are great TNG episodes but no one has mentioned one of my all time favorites…
Relics
Also, the one where O’Brien convinces his former captain to turn himself in because he’s gone rogue and is attacking Cardassian ships during peacetime.