I found the show to be perfectly watchable, but I’m not surprised that it failed. It had such a different tone from the other Stargate series that the title worked against them. It basically had none of the advantages of being a Stargate series (built-in audience quickly alienated, minimal continuity with the other series) and all of the disadvantages of being a Stargate series (potential fans assuming they won’t like it because they don’t like SG-1 or Atlantis).
The body-swap stones mostly just lowered stakes and created plot holes. There wasn’t much of a point in establishing that they had a field medic but no doctor or surgeon if they could just have Chloe (or someone equally useless) swap with an expert on Earth. They could have gotten a much darker tone (which seems to be what they were looking for) if they really were cut off from home, and lost people and failed missions because they didn’t have the right expert on board. Not to mention we wouldn’t have to deal with everybody’s loved ones back home.
The military/civilian tensions generally didn’t work for me. I liked that Rush had an ulterior motive, but Wray always seemed to be plotting against Young for no particular reason. If they had left Wray (and while we’re at it, Chloe) out of the series and given more screen time to Brody, Volker, Palmer and company, we could have had a more interesting civilian side.