Yeah, but they're not there, so...
Yeah. The thing is one is used to... rational characters, but that show is loaded with incompetent psychopaths. SG1 and SGA have problem solvers, SGU has problem procrastinators, I can't stand that.
They're just real people. Square-jawed heroes like Carter and Sheppard don't exist in real life. They're cartoon characters by comparison. You put real people in a hopeless situation and see what happens. Hell, look at some of the crap troops in the Middle East have gotten up to. Now times that by a thousand.
The child-like notion that they'd all play happy families and get along fine while they adventured though the universe is ridiculous, and wouldn't suit an adult show at all. If anything, I don't think they pushed the envelope
enough.