The best place for Trek to flourish for a long time, quite honestly, would be a basic cable series based somewhere like Vancouver and produced along the same lines as the Stargates or Moore's Battlestar Galactica. Trek fans (and the studio) would need to be willing to accept the trade-off of flying economy class in return for a chance at long-term viability. They might have to do with a couple fewer funny foam forehead appliances or space battles.
Can you imagine Star Trek on HBO? That would be wild.