I don't have cable, so I haven't seen SG Atlantis (yet).
However, for me, Stargate is like Star Trek - I liked it from the beginning, and it's like those crude jokes that Molson Export paraphrased: "... any Ex is better than no Ex ..."
(with the exception of that debacle with whatever that space station was called ... how can you "trek" if you're in a frikkin' space station parked by a drain hole ..."Star Wreck"?)
As for corny ... yah, whatever (meh).
Sometimes I enjoy relaxing, putting my feet up, and my brain in neutral ... (at home, that is - I'm not like the tards I work with who do this at the office ...)