I do not disagree with you on humanities' progression in SG1, but I'd think that all these mayor shifts in technological advancement would have been better explored in separate series rather than in one big swooping race to the max.

For example how Star Trek explored early space exploration in Enterprise (sans time traveling shenanigans), another era in the original series, and another one in The new generation and DS9 and Voyager.

I do like the stargate universe, the Atlantis spin-off in particular, and I would like to see more of it. Maybe they can set a new series in, say, 100 years from the ending of SG1. Or maybe it is time to move on to fresh ideas. I liked the universe of The Expanse, for example, and am looking forward how they can move it forward.

(I was less happy about the Dark Matter universe, or rather the story told in it, for example: one small ship with a small crew holding the balance and future of the entire (known) universe in their hands is a bit too much for me.)