Any scene with Riker commanding the Enterprise I'm a fan of....
Me too. I read that first Titan novel, seemed like a good start but I heard the series degraded.
Along those lines, I'd watch a Borg Apocalypse alternate universe piece. I'd watch a Star Trek anthology show birthed from the multiverse premise of Parallels, really. In a way, a two season run of something like that, is what the idea most needs: a sketch phase with a lot if ideas thrown at the board.
Then, pick the best and launch the long-term series off that. Mirror Universe episodes were always really popular. It could be great if it had a Black Mirror quality and edge to it, or it could degrade into Star Trek: Sliders.
I watched Star Trek: Renegades last night, and it was pretty darn fan-fic-y, but it was actually probably better written than either Generations or Into Darkness. :|