I've just started the show myself, and I'm having mixed feelings about it.
My biggest sole complaint is the militarism of the show. It's really sickening to see all this pretentious covert, confidential, top-secret portrayal of Stargate. It feels like pro-American propaganda in a way, with patriotism being flaunted everywhere from the people's attire, to how they speak. I also can't help but facepalm every time Hassel (sp?) contacts the president as though he's the single divine authority on everything that happens concerning extra-terrestrial affairs. Sorry, but a president is an iconic figure for a nation, most of their power is symbolic, and they certainly do not have super-human judgment or decision making abilities.
I have some other minor things to quibble about. It never seems to be addressed as to why SG1 can communicate with the people of other planets. Unless everyone is carrying universal translators like in Trek, why is it that every planet that SG1 visits can speak fluent English? We also find out that the gouaoul (or wtv they’re called) possess the knowledge of all their predecessors. How come then, does Tilk (sp?) seem to have rather noticeable gaps in his knowledge about Earth culture? There’s other inconsistencies I’ve noticed, more so than in the average Trek episode it seems.
As for specific episodes:
Children of Gods- What an awful opener. For one thing, you’re certainly missing out on references and whatnot if you haven’t seen the first film, which shouldn’t really be the case. That’s probably why I found a lot of this episode’s emotional moments to have virtually no impact on me. O’Neil talking about losing his son? I don’t know the slightest thing about him, so it’s pretty damn hard to sympathize him beyond what anyone would feel for a person they don’t know who’s experienced a tragedy. Carter came off as over-assertive and enthusiastic. IMO, if you want to be a female who succeeds in a man’s world, you do it by fulfilling a male role, not drawing attention to your gender and posturing about how tough you can be. I’m glad she’s a proactive female and all, you just don’t need to rub it into everyone’s face. Aside from that, the only positive thing I have to say about the episode are the cool villains. Snake helmets are a bit on the silly side, but otherwise I approve

Oh, and I love O’Neil to bits, his attitude is both humorous and gives a satirical contrast to the show’s militaristic nature.
The Enemy Within- A good recovery from the pilot. We get to see the influence of the gouaoul on a member of the SG team, which creates a cool inner struggle between host and simbiant, good and evil, etc. And, unlike the pilot, we can actually sympathize with the victim and the ethical dilemna the crew faces. Not a particularly amazing episode, but it’s setting the show on the right track.
Emancipation- We get it, ancient earth cultures treat women as property. This basically takes my Carter criticism and expands it to the full length of an episode. Though, I must say I am glad there was at least a conflict about whether SG1 should interfere with this Mongolian culture, or whether they should respect their customs. It reaffirms that despite the show’s arrogant attitude in many places, they can at least show some restraint in imposing their beliefs onto other cultures.
The Broca Divide- There’s not much here in terms of an ethical dilemna. SG1 finds a planet with people who are either composed or savage in nature, part of their crew gets inflicted, they find a cure, come back with it, and fix the problem. There’s also a laundry list of problems with this episode. The “untouched” regard SG1 as gods, and yet look at how they treat Tilk when he wants to draw blood from one of them! It’s completely contradictory to unwavering faith that someone would hold for a god-like figure. Then if Jackson got captured by the “untouched”, how did SG1 have such an easy time finding him? There were a couple other contrivances that bothered me a little.
Yeah, I know I’m nitpicking a little too much, but I’m not completely sold on this show yet.