About 4 or 5 years ago I started watching all the SG-1 episodes that were airing in syndication. It was on everyday, so there was no "gotta wait for friday" BS. After a couple of years, and a few rotations through the bajillion seasons, I think I've finally seen every episode. Atlantis I haven't caught up on yet, but I catch'em when I can. Sure, it was a bit campy at times, but I still had a lot of fun watching the adventures of the week.
SGU on the other hand, is looking to go for the more serious, gritty look. It's a reboot with the original canon intact. So far so good!
Also: Stupid tv shows on friday nights. I'm going to have to build a pvr or something one day.