SG-1 with MacGyver > SG-U > All other SG-1 > SG-A

And yes, there's a reason that SG-1 was the longest continuously running science fiction TV series. The story is good, you can relate to the characters, it doen't get terribly sci-fi until later on in the seasons, and the acting is good.