I guess I'll chime in to say I sort of dig the Stargate shows. I was always a big fan of the original flick (for better or worse) and was curious about the SG-1 show when it first started. I think I watched the first episode WAY back when it used to be on Showtime I believe (?), but then never really paid it much mind. Like most shows I got into them more on DVD (always a great place to go for TV show fans) and never really followed them when they were on the air. In recent years I've been trying to catch the shows I like as they air (like Lost). I usually miss the boat on great TV or jump on board when it's already too late (like I did with Angel).
I will never say that the Stargate shows are great TV, but I will say that I find them to be highly enjoyable. It stems mostly from the cast. The SG-1 show was on for 10 years and the cast fits together very well and they have a great rapport. Atlantis is similar. I dig the way the cast gels and I dig a bunch of the characters on both shows (as cookie cutter as some/most of them may be). Nothing ground breaking, nothing that hasn't been well worn elsewhere, Nothing that doesn't sometimes make no sense if you think about it for 2 seconds, but the casts have worked for me and thus the shows have worked for me. It also helps that the shows rarely take themselves too seriously, and it shows.
As for the new show, I don't know what to think. Perhaps I'll give it a shot, but who know. If for nothing else, I fell liek I have to see it to see what Robert Carlisle, Lou diamond Phillips, and Ming na are getting themselves into!