Having only watched SG-1 in a massive series run-through a little while back, I'm quite keen to watch again. My vague memories are, like most SF series, it started off really clunky (like a baby gazelle finding its feet © J.Archer). And it felt a bit low-budget with those endless recycled Vancouver locations. What ultimately made it start to work for me were the characters, esp RDA's humour and Tealc's stoicism. And the latter addition of all those great Goa'uld lords, Bra'tac, Sam's father and McKay.