I still like the 25th Anniversary game for the Nintendo and the Star Trek TNG RPG for the Sega Genesis.
As far as computer games go, I like more of the strategy/simulation games like the Starfleet Command series. Starfleet Academy was always a good game also. I used to have Bridge Commander and I liked it but I never liked it as well as Starfleet Academy. I don't think there are too many more that I've played and really liked.