*Disclosure: my son is named after an SG-1 character*
Yeah, SG is consistency personified: every now and again there's a personnel switcharound and you think 'oh no, the entire cast has been replaced by the guys from Farscape and/or Firefly, this is no good', but after an episode or two of settling in it's back on an even keel. Possibly the second quarter of the first season of SG-1 is a bit ropey while they establish a direction; later on neither Beau Bridges nor the repetitive tavern/marketplace sets on the Ori-storyline worlds ever really worked; and the TV movies were a bit weak, but other than that: consistently enjoyable, light-hearted, relaxing viewing, with very few mega-highs (the Groundhog Day one is very good), but even fewer ghastly lows. We've rewatched all of SG-1 and Atlantis a few times now, and yeah, it stands up.
Never grokked Universe, but am unjustifiably excited to hear what they have planned next.