10,000 episodes ago, Stargate SG-1 was a movie spinoff on Showtime that three people saw. Sci-Fi Channel and hiring Farscape actors and Stargate Atlantis came later. I never found the charm in it; Richard Dean Anderson is funny, but everything else about it is like white bread, if white bread had convoluted plotlines.
The creators revamped and re-released the first episode, ""Children of the Gods."
Good part: The fixes. A video featuring one of the show's creators lists all the fixes made for Final Cut. They updated video effects and fixed a visible scratch on one frame. The best change is removal of extra- dorky dialogue in a scene with O'Neill and Carter, and replacing it with a better, funnier take they filmed back then.
Good part: No nudity. The original series was on Showtime, where they show full frontal boobity twice, in silly, cheap looking scenes where naked women are menaced by the Stargate pharoah's goo-dripping stomach alien.
When it moved to basic cable, the nudity went away. So in the revamp, the nudity is still gone. Sure, we all like gratuitous nudity. What's not to like? But it's misplaced in a sci-fi TV show with MacGyver in it.
Bad part: "Children of the Gods" continues in the next episode, which gets no revamp. So you're left to scrounge up the first season DVD to see how the story ends.
Good part: "Children of the Gods" is a really good episode. If you've never seen any SG-1 it will entice you to try it out. Luckily for newbs, there are ten years worth of episodes to sample.
Bad part: "Children of the Gods" is a really good episode. The rest suffer in comparison.
The heroes go through hell, and there's no happy ending for them. Their loved ones get taken away. The end.
The setup for the series is brutal. But in the third episode, went to the old Star Trek trope of meeting aliens with a weird custom. The dangling plots from the first episode are not resolved for several seasons. The SG-1 team's quest for justice could have been excellent.
Instead, the rest of the series gives "Children of the Gods" ten years worth of swirlies. That is just mean.