Yup. Stargate was perfect. I don't like series with fully self-contained episodes, because those tend to not have any overarching plot. But I also don't like the new trend of running as many plot points as you can in parallel, which don't get resolved for half a season. I think StarGate got the right balance (and I miss the show very much).