Also, if you want some solid away team adventure, check out a few of these old Interplay adventure games: Star Trek 25th Anniversary and Star Trek: Judgement Rites. There is some great stuff to check out here.
Don't forget ST: A Final Unity, my personal favorite.
I'm a serious Trekkie, but I agree with you that STO is unlikely to match these older games for gameplay and that Trek feeling.
To be fair, I hate MMOs anyway, so I wouldn't be playing STO even if it looked great. But it would have been nice to see a Star Trek game done right again, which hasn't happened since Bridge Commander. So far the new movie hasn't kick-started the Trek gaming franchise either. All that we've had so far is that DAC game, and the less said about that, the better. I'd love to see a solid singleplayer ship combat game or adventure game in the Star Trek universe. Hell, they could even save on voice-acting costs by using new characters.