No I don't think I ultimately would, for a bunch of reasons.
I've said it before in this community, the 2 decades of "gritty realistic" heartburn drama ushered in by Battlestar Galactica cured my love of television. I don't currently subscribe to any streaming service and as they get more numerous, more expensive and worse I don't think I'm going to pick the habit back up.
I think I'm developing a contact allergy to resurrected IPs. Upon reading this I don't think "Oh boy a chance for more of my favorite adventures" I think "oh brother, some business suit with a neckhole infection has detected an IP they aren't monetizing hard enough." The most recent TV show to catch my eye was The Good Place, which is an original property. It was made because someone had an idea. "Do you think you'd watch a new Stargate show" sounds to me like "would you buy the industrial slop we're going to churn out anyway if we dye it the color of a thing you liked 20 years ago?" The one thing no one has there is an idea.
It's also just one of those shows where I don't know what you'd do with the setting. Star Wars and Star Trek, those settings are open enough to where you could go 90 lightyears to the right and still find cool stories. Shows like Stargate, Farscape and Babylon 5 are so character-centric that I don't know if I want to watch just another show made in that setting. Like, you could make me a Star Trek show that doesn't have the Federation in it. Set it on a Romulan warbird or something, it would work. There have been numerous works set in the Star Wars universe that didn't have to do with the Jedi or Rebels or Empire or whatever. What would you make out of the Farscape universe without Moya and the gang?
All other points aside, "the show is too character-centric and a spin-off could never work" is what a bunch of trekkies said when TNG was announced. No Trek without Kirk, Spock, and McCoy had any hope of being a good show.
Then TNG came out and it was fine.
For that matter, Atlantis worked just fine for me, as well. Universe didn't but that's mainly because it had focus issues and a weird tone. There is potential for a good new Stargate.
The question is, of course, what they'd do with it. The new Trek era has been pretty hit-or-miss and it's hard to say whether we'd get the Stargate equivalent of Picard or Strange New Worlds.
If it's another badly lit attempt at making a show out of nothing but curse words and scowls I'd pass. But if it's another fun, witty ensemble show that knows when to take itself seriously and when not to – yes, please.
See I knew someone was going to bring up TNG, that the original show was really Kirk-Spock-McCoy character centric and that was a big criticism aimed at TNG at first. And "Then TNG came out and it was fine" No it wasn't, the first two seasons are pretty rough, the show really found its footing in the third season.
I think trying to create a new Stargate show would be like trying to create a new show in the Hercules/Xena universe. Because they have basically the same problem: They ran out of ancient gods to kill before the series finale. I think they've already kinda proven they milked SG-1's setting dry because both spinoffs went "Meanwhile in another galaxy, something almost completely unrelated is happening."
Agreed. At this point seeing news of a new stargate show would instantly make me ask "what will they fuck up with this one?". I'd rather not see it replicated (heh) in nowadays' world of marvelized franchises and even continuing it would be meh, seeing as the scope and the stakes grew way too high even in the original shows. Basically I feel the show was a product of its time and taking it out would screw it up. Also streaming services should stop remaking every single IP and just come up with new original shows already.