My memory of Stargate SG1, which I have never previously watched in the intended order, was that it started off relatively sensibly as a SF/adventure show, and became increasingly silly as the writers became desperate. This was incorrect. I now realise that it starts off pretty damn silly, and on the whole, manages to maintain those levels of silliness in an increasingly elliptical and self-referential manner as it goes on.
I'm fairly convinced that if anyone in SG1 is a Higher Form of Being, it's actually Samantha Carter. She makes Buffy look underpowered.