Well, the story was a rehashed Children of the Gods, but with the added bonus of having Robert Patrick in it (whom I love in a heterosexual male-bonding way), and Weir, who is so unspeakably hotter than Carter, that words cannot express that.
Also, it had a geeky scottish guy, and a few good one-liners, courtesy of O'neill mostly, with exceptions. ("He's canadian." "I'm sorry.")
Of course the bad thing being the Wraith, who are about as cheesy as villains come. At least the Goa'uld were menacing back in the great old days of Apophis and Sokar. They are just silly.
As for the one thing that makes Atlantis different from every other show on the air - the production values. Aside from one encounter too many with the Columbian Pine(tm), they were lavish. Movie grade SFX, sets the size and quality of the Empire State Building, and so on and so forth.
And much big explosions. That's always good. And some of the cast has the potential to reach at least some level of SG-1'ness. Bar the token black guy, who similarly to enterprise seemed to have only 5 lines.