I just watched Stargate SG-1's 200th episode, "200", and it was simply incredible!
With ten years and (now) over 200 episodes under its belt, Stargate SG-1 has crossed the threshold from science fiction series to phenomenon. Part of the key to its success was that it has never taken itself too seriously; the show makes references to pop culture and even itself in semi-fourth-wall breaking moments. The 200th episode takes this and delivers it a hundredfold. It's a gift to the fans, of course, those who have been with the show from its inception right to the present.
The show ended with a really poignant quote, however, of Isaac Asimov:
Individual science fiction stories may seem as trivial as ever to the blinder critics and philosophers of today--but the core of science fiction, its essence, the concept around which it revolves, has become crucial to our salvation if we are to be saved at all.
And that's basically why I love to read and write science fiction.
So Stargate SG-1 remains cancelled. Or sort of. The issue is more that Sci-Fi, the channel which airs Stargate SG-1, isn't renewing it. There are rumours MGM, which produces the show, will take it elsewhere to continue it. I'm not sure if I'm so keen on that. Honestly, 10 years is enough for me. I would rather that Stargate SG-1 ends on such a high note than continue for another two or three years, slowly decaying until eventually it fades away.