OK, I admit it, I was re-watching Stargate Atlantis season 3 back to back, as you do, thanks to Sky On-Demand boxed-sets.
But the same applies to many TV series, especially Sci-Fi.
Almost every episode there is some peril that is un-surmountable, yes they always somehow find a solution or get unexpected help at the last moment. No matter how dire the situation.
Indeed, Stargate has been going long enough that the script writers take the piss slightly and comment on this some times.
But surely the characters in the plot should have noticed how implausible their life is by now? Why don't they notice?
I was pondering... life on Earth has resulted from such unlikely sequences of events and continues in the face of huge risks from meteors, volcanoes, some of our own stupidity, and all sorts. We are so implausibly lucky...
[No, I don't believe in a "script writer" either, honest, it is just that the lucky ones are the only ones that get to reflect on how lucky they have been, that is all]