They had access to a lot of Ancient artefacts which they didn't really understand; despite many oddities that came to mind since first watching it, I think it would still fit the setting that they didn't know how to get the Ancient's 3D printers (or whatever) to spit out better hardware — if they could make it spit out more hardware on demand, even if they "could only find one file to print", it would radically change the show.
This also means there was no way for either SG-1 or Atlantis to sensibly continue past the SG-1 finale, when they got Asgard replicators and all the instruction manuals for them… and that Star Trek TNG onwards is best done without thinking too hard about the implications of almost any of the tech they demonstrate.
I really didn't like the direction that SG-1 and Atlantis took.
There was a novel that took place after the movie that depicted Hathor coming back and trying to take over with a simultaneous plot of the US trying to extract resources from Abydos. I though it was really we done and wished that SG-1 used it as the starting point.
I can sympathise with that; while I enjoyed both, they were a radical departure from the source material and non-trivial departure from the SG-1 pilot (which I only learned recently was initially a made-for-TV film).
A made-for-TV film for Showtime, at that, which is why the pilot has nudity and an R rating and the rest of the series pivots into more family-friendly territory.
This also means there was no way for either SG-1 or Atlantis to sensibly continue past the SG-1 finale, when they got Asgard replicators and all the instruction manuals for them… and that Star Trek TNG onwards is best done without thinking too hard about the implications of almost any of the tech they demonstrate.