Did we watch the same show? The only drug-addicted person on the ship was well past millennial, and the various skills of the crew were what allowed them to survive.

It wasn't what I expected of Stargate, but it was watchable.