Star Trek DS9: Crossroads of Time on Super Nintendo.
My favorite memory of it was from the first day: a friend telling me I couldn’t use the same phaser twice against Borg drones. I was confident they wouldn’t put a detail like like that in a game. Not two seconds later, the very next drone blocked my phaser. (Clearly one of Trek’s ongoing lessons in the arrogance of man. Ahem.)
Seems silly looking back to think game devs wouldn’t care as much (or more!) as I did about Star Trek to add in ideas like that.