Depends. If it's like SG-1 and Atlantis I'm 100% on board. If it's more in line with SGU... it's more like 60% on board. I felt like SGU could have been way better, but several story plots got rushed and abandoned and certain plot points got pushed hard that were really... uninteresting IMO. But the show overall kind of... made the mistake when they introduced a lot of space ships and sort started losing it's identity. Like the stargates were just faster to get around in but no longer needed for most things.
I've had an idea in my head for a while, like some new scientist who's been working off of Carter and McKay's work has made a discovery that the gate goes to a lot more gates than they thought. Re-makes the DHD Carter made with the new research and better tech creating a "Master Gate" or "Master DHD" (basically a gate that has the training wheels removed, IE Ancient 'Admin' access mode) and the gate now travels to a whole separate gate systems that no one new about before. Leading to meeting up with certain species that were only seen like once like Oannes, to find that Nem wasn't the lone survivor of the species but was stuck and was the last survivor of the expedition. A true Nox home world (suggesting the planet we see them on was just a settlement/outpost/etc) and even the much anticipated Furlings can be found.
I'd be okay with picking up SGU where it left off, using the cryosleep break as an opportunity to recast and retool as needed. I think the show's first season was weak but it was really picking up and getting interesting in the second season. I can think of a bunch of interesting directions things could go from there.
Of course, everything is predicated on "is the writing good?" If you have good writing you can make something awesome out of almost any premise. And if it's bad event the best premise won't save you. It's even worse when it's bad writing on a good premise because it "ruins" it for future attempts.
Oh, man, the opportunity to explore what humanity must do or show in order to be allowed to continue participating in a "higher level" of inter-galactic society that this opens up! I guess that'd be my hypothetical "make it or break it" issue if such a show was made: do they explore this issue, and how well do they tell this part of the story?