Star Trek: Online
is a bit silly in that it's essentially just everyone in the Alpha Quadrant going. "COME ON! LET'S GET NUTS!"
Still, I think it was a fairly well-realized MMO and the "Needs of the Many" was very enjoyable to me.
I wouldn't mind if they mined it for material. I'd also like to see them mine "New Frontier."
I think the Expanded Universe of Star Trek is fun but Star Trek Destiny's ending didn't sit right with me.