If I was placing bets , I'd say this one is doomed from the start....BUT Supernatural is far from a bad show. It's not in my A-list but the lore is very well researched and mostly based on real old legends of monsters for the most part and it gets huge points for the rogue angel's look based on JC.
My only big bitch about the show is the focus on "feelings" that occurs at the wrap up of each episode.
I would say that the CW is a strange home for Sandman and agree that AMC/FX would be best , but as long as the big 4 networks stay way it has a fighting chance.
The Dark Tower on NBC fills me with dread.