If by games you mean video games, Bridge Commander is one of the better ones and supports a large amount of mods.
If you're more into FPS, Elite Force and Elite Force II are amazing.
I'm also partial to Starfleet Academy.
Hope this helps!

Definitely 'A Final Unity', which runs more like a very extended episode including puzzles within the storyline. Gets the tone just right IMO and isn't a half bad storyline. The precursors to this, in game play style at least, but set in the TOS timeline '25th Anniversary and 'Judgment Rites' are also pretty good but may appear dated. There was a similar style DS9 game too, 'Harbinger', but wasn't as good.

The Borg and Klingon games are quite interesting, in that they are all live action and so very much like partaking in an episode of the show. However, they can be quite linear in their game-play and impossible to get working on anything that's not a Win95 PC - even in compatibility mode. However, someone had a while ago managed to extract all the video and put it up on to youtube cleverly using internal video links to take you to the correct part of the game-play. Not sure if it's still up.

I am a bit scared of getting into the mmorpg thing. I know this one guy who basically lost 4 years of his life to WOW. I was never into fantasy so WOW never posed a threat to me, but star trek online? It either is shit and i wasted my time or it is great and i will .. you know waste my life away there..

Second STO. Check out /r/sto is you want to see the online community. Peeps are pretty friendly. And as others have said...STO's not the type of MMO where you'll play for excessive hours. Hell, even leveling is as hands off as you want it to be...many of my captains are leveled using the DoFF (Duty Officer) system. The DoFF system lets you send Duty Officers out on timed missions for exp and loot. Basically you can log in every couple hours and select new missions then log out and still level pretty fast that way.

This is a valid concern. I tried out WOW and got hooked - but it got the point where I'd play for hours and want more time. I remember the box even said something like "play for an hour or a whole day!" and that is not true. I had fun but wouldn't be satisfied unless I spent long chunks of time playing, and felt like I wasted my time when I did end a session.

I'm curious about STO and will give it a go eventually, but worry it might be the same.

I stand by Interplays's Star Trek 25th Anniversary and its sequel Judgement Rites. It's a click-based adventure game with puzzles to solve, items to find, and decisions to make. One of the great things about it is that there are multiple avenues to beat each level, and you are rated based on decisions you make in interacting with other characters (especially through dialogue). If you're lucky, you can find copies of both that feature voice acting from the original cast. You'll probably need to get a DOS emulator to run it (like DOSbox).

The most recent batches of Trek games have all been garbage. STO and Legacy were highly disappointing.

You have to go back at least 5 years to get good ones, but really Trek games hit their peak in the 90s. The best Trek games are:

Bridge Commander - don't forget the Kobayashi Maru mod!

Armada, you'll need to hunt around for the unofficial "1.3" patch to get it to work on XP/Vista/7

Armada II, but really only with the Fleet Ops mod, which balances the game and removes the confusing, pointless, superfluous 3D battlefield. Unfortunately it's multiplayer only with the mod, but there is an active, albeit small, community.

ST 25th Anniversary and TNG A Final Unity if you're looking to feel like you're on the show, but you'll almost certainly need DOSBOX to run either of these.

I always enjoyed Klingon Academy, even though it's older. Christopher Plummer acting in Star Trek game made me quite happy. Plus the damage system, while a bit slow to take effect at times, was quite nice. Nothing more pleasing than taking out a ship's impulse drive and weapons and then floating over them, gloating.

It's not strictly Star Trek related (unless you use one of the several excellent Trek mods) but Artemis Spaceship Bridge Simulator is an awesome Star Trek experience if you can get a few friends with laptops together.