It's decent. But yes, you really should see SG-1 if you haven't already. It's a much better show and explains a lot of what will be happening later in Atlantis.
The whole franchise is great because although all the episodes are stand-alone, there is definitely a big storyline progression as well. Each episode builds on the last, but they also keep it simple for those that are new or watching for the first time.