This show definitely had some excellent episodes and a decent storyline to build on and live off of, but, like many shows that run for so long, it eventually got predictable and showed up with some pretty boring stuff. The characters are all quite decent with the exception of Jack O'Neill. I mean, don't get me wrong, he plays an important role and has his great moments, but his character is ridiculous most of the time. His sarcasm and lame jokes get incredibly old and at some times so predictable that it makes your nose bleed. But I mean no disrespect to Richard Dean Anderson himself, because his character in this show doesn't necessarily do him justice.
The humor is mostly cheesy nonsense and is often used at the most inappropriate times, but there are some intentionally hilarious scenes throughout the show. It's often Teal'c who delivers the laughs, which is quite strange, since he's the most serious character.
My final complaint is the combat. The camera seems to imply that they're trying to trick you into thinking that that heat of battle is coming down hard on all of them, but take away the fast changing scenes, and you'll have 30 trained enemy soldiers shooting directly at two members of SG1 and missing by a mile with every single shot.
But I must say, my review is negative but the show show is great. It just has a lot of annoying things attached to it.