My huge unsubstantiated opinion comes from listening to my friends who like me feel the same way. We've begun to refer to the show as Stargate: Eastenders. Admittedly those only the 20-30 people I know but as you said most people were as for less drama and more shooting. Sure that is just anecdotal evidence but reading this thread shows it is a common opinion.
People were not asking for no drama and any good action story will require a plot. It doesn't need a great plot but one needs to exist. Stargate SG1 and Atlantis both had multiple plots and story arcs, they were not great or even complex but they were compelling. SGU had none until a quarter the way through the second season.
I have watched some of the earth stories but after the first few I decided it was best to skip through them. That doesn't mean I missed all of the story I simply fast forwarded and checked nothing interesting was happening. The only ones I've seen that were meaningful were the Greer story and when Rush was in the chair. The rest have generally screamed filler.
I went to a school in the top 30 in the UK, most of my friends went to Cambridge and Oxford Universities because of their ability. Most of my life has been spent with people with IQ's above 140. I say this not to insult or intimidate but to clarify where I am coming from. While the social awkwardness of character's like Sheldon, House and Bones is funny, it is not a requirement of intelligence and in my experiences isn't even that common. The dysfunctional are often perceived to be intelligent even when they aren't, for example most people assume geeks are smart.
Even assuming anyone with an above average IQ would be heavy dysfunctional that would only explain Rush, Eli and the scientists. The colonel, Scott, Greer, Cloe, etc.. should be reasonably capable, however even the normal civilians and military personnel are deeply flawed to the point where it would have be hard to see how they achieved their positions in a normal environment let alone how they would qualify to be sent into space.