I think SyFy made the right decision to drop the show. The show just wasn't that good unless one was a fan of the books, which I haven't read nor am willing to buy the series. I liked it because it was a beautiful show. But, at $85 million per show, I think they made a mistake on making that one. Scifi shows usually lose money until syndication and I don't see this show ever making a return on investment. SyFy is not big on long-term and reliable syndication.
SyFy in general, in my opinion, is a crummy channel. However, they do get things right occasionally. I don't think any of the entertainment media are worth the time of day, but I like to be entertained and tend to overlook most of the garbage. I stick with amazon and netflix because of choice and no commercials. If I find something I really like I buy it on disk, but only at a very good price and used, if possible.
TV, movies, print media, news media, all of them are forgettable and untrustworthy. They could be gone tomorrow and I wouldn't care. The only time I consume them is in the evening when I am resting from the day. During those times when you're just killing time until the rapture, they get the job done.