I even liked the SF shows that Sci-Fi Channel used to run, before it changed its name to Syfy (what the hell is a siffy anyway?) and clogged its schedule with bullshit ghost-hunting shows. Things like Farscape and, uh, well, Farscape.
Here are some of the SF TV shows I've watched and liked:
UFO
Star Trek (in all its various forms)
Babylon 5
Battlestar Galactica
Lost in Space
The Time Tunnel
The Starlost
The Adventures of Briscoe County Jr. (not technically SF, but it DID have an orb)
Space: 1999
Buck Rogers in Whatever The Hell Century This Is
Farscape
Firefly
Space: Above and Beyond
Voyage to the Bottom of the Sea
Land of the Giants
I liked all these shows, and some of them I liked an awful lot.
I mention this mostly to demonstrate that I'm not some realist literary type who thinks science fiction is mere "pornography of ideas", as someone once said (it might have been me, upon seeing the cover for the Space Plumber novel. It wasn't called Space Plumber, but that's what the hero was. I wonder if a plumber in a spacesuit would exhibit butt-crack. But never mind.) I mention this so when I say that there are two wildly popular SF shows that I don't like, never liked, can't like, never could stand, you understand that I'm not exactly a hater of the whole genre.
The first is The X-Files. Honestly, the whole men in black government conspiracy grey aliens Zeta Reticuli business wears itself out on me very quickly. Like Brylcreem, a dab will do me, and for quite a while. Since I don't really dig that whole dark gummint UFO conspiracy business, I didn't really dig the show, and was always kind of mystified by its wild popularity. And it isn't because there were aliens and UFOs in it. Got no problem with aliens and UFOs - for years I had posted on my office wall certain choice quotations from G'Kar, and I think personally it would be really cool if there really were alien spacecraft at Area 51. But the whole conspiracy thing quickly turns into drudgery for me.
The second is Doctor Who. The wild popularity of this show remains a complete mystery to me. Maybe I'm missing something. Maybe I was supposed to do some reading before watching the show. But man, is it ever tedious and uninvolving. Back in the days when Tom Baker was the Timelord, people at work used to change their work hours so they could get home in time to catch it on PBS in the afternoons (this was before TiVo, obviously). I tried to catch the wave, and failed utterly. I could list a whole series of defects, like the fact that the Daleks were the least convincing villains in the history of television. I mean, come on, you could stop the Daleks dead in their tracks by spreading a little gravel on the sidewalk. They'd get high-centered, spin their wheels, and that would be that. But fundamentally, I didn't like the characters and didn't care if they lived or died. And I got really tired of people at work blathering about their sonic screwdrivers and debating the significance of Dr. Who's scarf. To paraphrase an alleged quote of Dr. Freud, sometimes a scarf is just an affectation. The only good thing that I could see in the whole tedious mess was, frankly, Elizabeth Sladen.
So that's that. I never got into the whole paranoid conspiracy theory angle of The X-Files, and Doctor Who never convinced me that I should give a rat's ass what happened to anyone in the show.
I'd much rather watch Space: 1999 than either one of those clunkers.
I am forced to withhold judgment on the whole Stargate business. The movie was kind of goofy but worth watching a time or two, but I have no idea what the show is like. As a matter of principle I don't watch "Syfy" much anyway. If they're that embarrassed with the label "science fiction", they probably wouldn't want me hanging around their channel anyway, what with all my Star Trek models and Alien mission patches and G'Kar quotes.
Just to give you a taste, here's my favorite G'Kar quote:
G’qon wrote that the war we fight is not against powers
and principalities, but against chaos. There is a greater
darkness than that which we struggle against, and
worse than the loss of life is the loss of hope.
-- G’kar