Stargate SG-1 is the best SF show on television. Yeah, the movie was kinda lame. But there was a great idea behind it, and the TV series ran with it. And it did it with panache. Sure, Richard Dean Anderson's Colonel O'Neill is utterly absurd-- nobody with his irreverent attitude could possibly survive in the upper ranks of the air force, let alone lead an elite team responsible for interplanetary exploration. Sure, Major Carter can bring home the bacon and fry it up in a pan. Daniel can decipher every ancient, dead language ever written on Earth, and Teal'c has fewer notes than a test of the emergency broadcast system. Granted, all of it. But the show gets almost everything else right.
The production values are terrific. As ridiculous as O'Neill is, his dialogue is hilarious. The cast clicks and is eminently likeable. The series has an astounding grip on its continuity, with characters and plot elements resurfacing frequently (I'm particularly fond of 2010, where the team realizes the dire consequences of trusting a certain alien race and sends a message back in time to warn themselves, and then 2001 the following season where we see the team first encounter those aliens and change their behavior based on that message).
The show floundered this season with Michael Shanks' departure (he's returning next season). It says something that the best episodes this year featured his guest appearance. And while the scene with Daniel and Jack in the elevator was one of the best all year, tonight's season finale got Daniel all wrong. He'd never give Anubis the Eye of Ra, especially after learning what Anubis is, which would justify acting against Anubis directly (although not, apparently, in the eyes of Uma). This episode missed the boat in other areas as well, such as the complete lack of emotional connection between Jack and Skara and the treacly ending.
Yet even when it misses, Stargate SG-1 is still better than 90% of what's out there. If you haven't discovered it yet, check out the reruns on the Sci-Fi Channel.