I love STBC aka Bridge Commander. I sure have it nodded out pretty heavily but primarily having the Galaxy charts and Kobayashi Maru mod gives it a lot of life. You can make your own ships, have fun with face replacements and voices, pack it with real solar systems and all kinds of customisations. It’s a lot of fun. Fir a flashback now and then, I also play an old Star Trek game from SNES. Budget as hell but good for a laugh.
Just ransacked through my archive and there it was: The first game I ever bought by myself - TNG: A Final Unity Didn´t even lock at the box for over 20 years. Never tried it for 25 years, but DOSBOX should work - i hope. But SFA will come first.