This is not only a problem with Greenlight, though. There's a game called "Uriel's Chasm" in there, apparently it does not come from Greenlight (though I'm not sure). Just read the reviews... And now consider that this (and the other game from the same developer) are still above the worst Steam has to offer. At least they run. I remember when Steam was great, because you generally could expect a game bought there (even an oldie) to work without additional finagling, and to be of reasonable quality. Now, you can't. Steam has everything now, and 90% of everything is crap, as per Sturgeon's law. It's a good thing that it has the review system, at least.
As for Hatred, I think that most people that try it will be only interested in controversy. If it wasn't for that, it'd be absolutely unremarkable. It doesn't seem to have neither the quality nor an interesting enough premise to be really competitive. It'll only last as long as they can keep the buzz going on around it (indeed, if Steam didn't decide to censor it, we'd have never heard of it). It doesn't deserve getting taken off Steam, but it doesn't look like it'll be a huge success.