I was skeptical that I would like SG-1 but my wife and I bought season one on a whim. Just to have a new sci-fi show to watch. By the time we got through the first season we were hooked. I don't think anyone can fairly evaluate the show without watching an entire season. Start like I did and you will find that it's almost as good as Star Trek. I said "almost"!
I have also enjoyed Atlantis for the most part but SG-1 is my fave. I am looking forward to the two direct to DVD movies this year and the possibility of a third series.