I share your Syfy concerns, though I read recently that the head of Syfy admitted they dropped the ball after Galactica and Stargate, and now they're trying to make up for it.  So I'm sure that they're going to push for this and their other new properties to be as high-calibur as they can.

Game Of Thrones is the high water mark, but remember how much of that first season was people sitting around or standing around talking.  Even the "big battle" wasn't even there, Tyrion was knocked out before it started.  The budget got higher in each subsequent season, but they still had to fight for all of it.  I don't know what they're going to do for Krypton.

This is making me realize what a smart move Smallville was, you can find little farm towns everywhere, Metropolis could be shot in any city, the bad guys were all people who got their hands on meteor fragments, and a lot of the show was just teen angsty drama... cheap to film.  The effects were expensive, sure, but since it takes forever for Superman to get his powers, you only have to do one at a time.