Here's where I stand on the sci-fi thing:
Farscape is the measure by which I guage all sci-fi anymore. On a scale of 1-10, Star Wars is a 10 and Farscape is an 11. Other sci-fi? It varies wildly.
Babylon 5... never been able to watch an entire episode without falling asleep, so I couldn't justly rate it. Andromeda... mega-crap. I wouldn't call it Hercules in space, because that would be an insult to Hurcules.
DS9 and VOY are what I consider low-points in the Star Trek saga. Both were generally more entertaining than whatever else was on TV at the time, simply because of genre, but I could never get into either one. They were just boring.
TOS and TGN were the good Trek series, if you hit a good episode, which was most of the time with TOS and about half the time with TGN.
Enterprise? It's the only Trek series since TOS where I've been able to stomach most of the episodes. I LIKED Enterprise. Still do. Good characters (Archer & Phlox somewhat, but especially Trip & T'Pol) make the show, and I'll be sorely disappointed if the Save Enterprise campaign fails as badly as the Save Farscape campaign did (which is likely, so I suppose I have sore disappointment to look forward to). On the plus side, everything I've heard about the upcoming episodes sounds very, very good and once the show gets past the admittedly marginal Andorian/Tellerite/Romulan arc, it's shaping up to be some of the best trek since TNG. The "Why Klingons have flat foreheads" arc, the mirror-universe 2-parter, and the whole convoluted Trip/T'Pol bond & baby thing prove that at least the show will go out on a high note and I won't be the only one sorry to see it go.
Stargate... it's good stuff. Always entertaining, and that's what counts, not realism (it's sci-FI, for cryin' out loud). You watch the show because O'Neill is funny, T'ealc and Dr. Jackson are sometimes funny, because Maj. Sheppard is a blatant O'Neill wannabe, and Dr. McKay is actually funnier.