Here's a question that is slightly on topic: Since the show is cancelled, will they release the season 2 dvd as a whole season or split it up? I really hate it when they split seasons.
I hate that too. At least I'm glad that 20th Century Fox is starting to realize that and is releasing its shows in both formats (as evidenced by the 1st seasons of
SGU &
Glee).
As for
Stargate SG-1, I'd largely agree with the sentiment of Seasons 4-6 being the best, although Season 6 sees the beginning of the trend of writing episodes to feature Jack O'Neill as little as possible while still making him a vital component of the show.
Season 7 has a lot of good episodes but also some real crap ("Space Race," "Avenger 2.0," "Inauguration").
Plus, that was when I realized that the show wasn't really going anywhere or building up to anything pre-planned. They just wanted to milk it for as long as possible. Fair enough. I might like it more on another re-watching now that I've adjusted my expectations accordingly.
Season 8 is mostly forgettable except for the last 5 episodes and a couple other Daniel-centric eps ("Icon," "Prometheus Unbound"). Most of the episodes really feel like they're scraping the bottom of the barrell for ideas (especially "Avatar," "Affinity," & "Covenant").
But honestly, I suppose I really need to go back and rewatch a lot of the show. It's been ages since I've watched anything from before Season 9.