While Stargate SG-1 may not be as good as I originally blathered when I first started watching (somewhere near season 4, which is more consistently good than other seasons), I still watch and enjoy the show. I've had to watch the show rather ridiculously out of order, which is an annoying way to catch up on the plots. I had to get one of the DVD's from Netflix to catch the second part of a two-parter, and noticed they are much more satisfying to watch on DVD, probably due to the image quality and the lack of commercials (and some decent commentaries). I once tried watching an episode of the abysmal animated Stargate Infinity (but do kids like it?). I also revisited the original 1994 movie, which was as badly written as I remembered it. Better music, lots more extras, and it was refreshing to see a planet that didn't look like Vancouver for once. (But gah, the script!)
Now there's finally official news of the full-blown spinoff series Stargate Atlantis (with a pretty picture on the official site), and I can't help but be excited. With SG-1 having jumped (pretty recently, I'd say, though again, I'm out of order), it'll be nice to see what a fresh cast can do.
I'd pay money for a quality Stargate video game. Of course, the game I imagine is heavy with clever Myst-like puzzles involving alien technologies and languages, rich backstory, and hours of full-motion video cut scenes. But the Stargate franchise seems built for it, more so than another boring FPS. There are some old ones, but I don't have a Sega Game Gear.