If I understand it right, the one Star Trek game actually involving ship combat that ever seemed to be worthwhile is the 20 year old Bridge Commander. That's based on what I'd heard about ten years ago. I did manage to get a copy but for whatever reason never got into it. It was supposed to have a decent mod scene back when, but I have no idea what it's like today. The TNG point-and-click game had, if I remember right, a fairly intricate ship combat module that was used I think twice in the game, if that. I remember vaguely that it was an okay adventure game, but was a little buggy and unintuitive. Frankly, though, talking about Star Trek these days just depresses me–they finally get out of the reboot and revisit the era I actually enjoyed, and it ends up being trash. I didn't exactly have any expectations, but you can be disappointed without having expectations all the same. As far as video games? As you more or less implied, most of them are bad to different degrees. Nowadays all the fans of the series are old and clunky and it's unlikely that anything good will ever come of it–the alternative was to go the Star Wars route and get the occasional bright spot before the series disappears into the bland pop cultural porridge of appealing to normalfags. I mean, having said all that I absolutely admit that my nostalgia for 80s-90s Star Trek is nostalgia and nothing but that. Fortunately, the old episodes are still around if I want my fix of beige walls, plastic models blowing up, and technobabble.
