SG-1 is a great show. It holds up surprisingly well for its age. Strikes a great balance between serious and light-hearted, and the self-contained episodes often have interesting ethical or social issues. I'm also fond on how the early episodes emphasize that humans are new to interplanetary travel and are still figuring things out. There are several episodes where SG-1 travels to another planet and actually messes things up, making life worse for the natives. And the show did a great job with having things change in-universe.
There are some cliches and flaws, of course. My least favorite part is probably how non-permanent deaths were, they really overdid the whole thing with characters dying and coming back to life, or being cloned.
I'm surprised that Stargate has had some sort of franchise curse where other media never succeed. They had two more shows in the franchise (I'm in the minority that loved Universe, and I think Atlantis was for the most part bad), but never a movie aside from the one that started the franchise, never a game that succeeded (most attempts failed to even ship).
There are some cliches and flaws, of course. My least favorite part is probably how non-permanent deaths were, they really overdid the whole thing with characters dying and coming back to life, or being cloned.
I'm surprised that Stargate has had some sort of franchise curse where other media never succeed. They had two more shows in the franchise (I'm in the minority that loved Universe, and I think Atlantis was for the most part bad), but never a movie aside from the one that started the franchise, never a game that succeeded (most attempts failed to even ship).