My favorite episode of star trek is when the Enterprise is marooned in the middle of space for 5 episodes and then a massive enemy fleet crushes them. Aaaah FTL, good times.
I am going to do a deep dive into lesser known Star Trek titles soon on the channel but I feel the most Star-Trek-like experience a game could offer is a point-and-click adventure with branching narrative and that stuff isn't - unfortunately - for everybody.