Having watched this back in the late 90s I thought I would check this out again and more or less in order.
Season 1-5 seems to be the most classic Stargate, but for some reason season 6 so far has completely change tone and I’m not sure why. I can only speculate that the writers wanted to try different stories.
For example Shadow Play (S6 E7) is far more political and slow in progression than other episodes.
So apparently S6 switched production from Showtime to Syfy or something.