The issue that most of us are having is that these people are TOO flawed to have been in the situation they were in before they got onto Destiny.
Like what? I've been watching the show and I don't really see any major flaws.
I don't care that Young seems fixated on salvaging his relationship with his wife, at least he's still functional. 3/4 of the people we've seen would be dead 20 sec into a battle with a squad of disposable Jafa or Faceless wraith, because they're virtually catatonic right now.
Considering most of them are civilians, that makes a lot of sense.
But you're mad the soldiers aren't at the ready? Against who? They're on a ship in the middle of nowhere with zero to do.
What are the soldiers supposed to be doing on this ship?
Stargate as a franchise was built on exciting situations in alien environments with semi-predictable, verbose, over the top villains. It was popular because it was a comic book on television. Now you've taken away my comic book and handed me a psychological thriller with no murders, violence, scary situations and precious few thrills and told me it's better. When there's no heroes and no real villains, you don't have drama, you have people standing around talking about the weather or in the case of SG:U, people hiding in a dark corner crying about some childhood trauma.
So far my reaction to the whole thing is 
That is exactly what I want. I don't want villains and heroes.
I got tired of watching Carter, O'neill Teal'c, Jackson and whoever never lose, never die, nothing. They do everything right and everything turns out well at the end. That's why they had to keep ramping up the bad guys all the time. They ended the first show by practically beating gods. I guess all in a days work, right? I got tired of watching the same half dozen people kick the ass of an advanced race or teaching pseudo medieval cultures all about modern society.
I'm not sure what you guys want. Them to get control of the ship and fly around shooting funny looking aliens?
These are the people I expect to see on projects because these are the people we see every day. Brilliant scientists with antisocial behavior. Soldiers with no one to fight.
That was what I hated about Stargate. No one suffered from stress, or was scared.
A top level project? I expect ambitious jerks looking for ways to move up the ladder. Antisocial people who are brilliant at what they do but are so neurotic can't interact with others well. People dealing with withdrawl from things like caffeine or nicotine.
Does everyone have to have these? No. Do they all have to be there? No. But this military complex of people that never make mistakes or have flaws is boring and in my opinion just not real. You can't create a perfect team like that.