It’s Stargate — it’s great, but it’s not without its problems. Most of them are small: a few wobbly sets here and there, and some CGI that looks a bit rough in 2025. It all gets better the further in you get.
The one big issue with SG-1 is some of the early episodes. There’s is poor representation of women, and Episode 1 in particular is not good — the unnecessary full frontal nudity really isn’t needed. It’s only a few episodes that have these issues, and Episode 1 is by far the worst. By Season 2, those problems are pretty much gone.