I enjoyed SG1, and so did my wife who is not at all into sci-fi. She liked it because the aliens didn't have all the prosthetics, making it easier to follow the plot without all the distraction. I liked it because it could make fun of itself. That's a lesson that other shows could learn.