I love Stargate. It's nowhere near as good as Farscape or Trek, but it's lots of fun. Although, its share of bad episodes is way too big, if you ask me.
One of the things I hate the most about it - two thirds of all the planets SG1 ever visited look like Canada.
Not that there's anything wrong with that, it's just... You'd expect more diversity in the universe, that's all...