What needs to be kept in mind with Sci-Fi shows is that they cost a lot more when compared to most television shows and that makes the networks hesitant to make them anymore. It's very unfortunate but they can throw up another sitcom, reality television show, cartoon, or yet another drama that has virtually been done a thousand times before and we are sick of, and they can save a ton of cash even if the shows they put on aren't as successful or even well done for that matter.
That's the real problem with Sci-Fi. Cost. Whenever a show is billed as Sci-Fi, everyone starts thinking about special effects and that's what can doom a new show.
Oddly enough, the "solution" to bring back Sci-Fi would be the Star Wars TV show. The problem with Sci-Fi (on television, at least; Sci-Fi films need no help) is that it is hard to get people to watch a new show. Just look at Firefly. If you want to bring back Sci-Fi, you need a show that will make tons of money. Pretty much no matter what, a live action Star Wars would be a huge hit and it would definitely bring back an urge amongst networks to develop their own Sci-Fi shows. CBS could even possibly bring Star Trek back to TV, which would only make the urge bigger. If we had these two TV shows back we'd start to see new series, just like how the 90s saw shows like Babylon 5 and StarGate.
I think a Star Wars show may face problems. There would be tremendous hype, but the question is, where/when would the story take place? I can't see a Star Wars show doing well unless if takes place some time after Palpatine is killed by Vader. If it's done as a prequel to either movie series, in a sense you'd know the ending and that wouldn't bode well for the show.
As for a new Star Trek show, I think a good premise would be to try and get back to what the original show was about, exploration. And, a good way to do this would be a new class of ship, Quadrant Class, where they wouldn't be confined to just the Alpha Quadrant.
As for a new Star Trek movie, I would like to see one last movie with Picard and company, and even mix in characters from the other series. A great premise for the movie could be a full-scale invasion of the Alpha Quadrant by the entire borg collective and the Federation forms an alliance with all the fan favorites, Klingons, Romulans, Cardasians, Tholians, Breen, etc.
Babylon 5 - I truly hated that show.
StarGate was awesome, but it kind'a went off the rails with the Ori storyline.
I swear, I have no idea what everyone's problem with Enterprise was. I didn't have the chance to watch it when it was a show, but I went beginning to end on Netflix. I really liked it. Obviously, the Star Trek franchise is always going to water down what they do, but I enjoyed the show. I especially liked the juxtaposition between the very beginning, with everyone being eager and optimistic; and when they finally got back to Earth, burned out and pissed. The part where Archer is out with the hot Captain of the "Columbia", "Forget diplomacy, don't worry about first contact, screw giving aid. Pack as many weapons as you can carry, then pack a few more." (ad libbing, of course) Anyway, I enjoyed it and I'm sorry they cancelled it. One more good Sci-Fi show, gone. And all we're left with is this new movie crap, which isn't going to work out anyway, and if it does we still have to wait for years for the next one. Bullshit, with a side of bullshit, heavy on the bullshit.
Enterprise suffered from being an expensive show on a start-up network. The first season sucked. The second was better, but not that special. The third season was better than the second, and the fourth season was truly awesome, except for the series finale which was a piece of shit. Based of the great storylines of the fourth season, the show ended too early.