Easily my favorite SciFi series of all time.
The recent-ish Travelers from Brad Wright had some good episodes.
I'm a die hard fan. I started watching Stargate SG-1 when I was a kid in 1997 (season 1). I've seen ever single episode of every series. Every movie. All multiple times.
I REALLY don't want to see a modern reboot that is like Star Trek Discovery. I'll be so disappointed if they do.
I do think it is possible to revive the franchise and make a compelling show. However, it would be tough to pull off. I love that the show never took itself too serious. Stargate Universe was the opposite and flopped because of this.
Though actually, maybe that could be the impetus for revealing the Stargate to the rest of Earth, as backstory to the new series...