Yeah, I'm half with you, Matt. But SG-1 went for 10 years as a series, and all good things must come to an end. Try the official DVDs if you want more - commentaries, behind the scenes, etc. Opens up the universe some more.
Oh, have you tried the Stargate audio books recently released? I've heard a couple, they're pretty good.
Uhh, what else? You can find the same actors in other shows - The Outer Limits especially. Made by the same company too.
Sorry if you knew any of that.
Ah yeah, and we disagree on Infinity. Yeah, it's cheap and cheesy, but I like it! Not as canon, but stand alone entertainment.