I like Greenlight just fine. However, the thing to keep in mind is that it can take a while to investigate the details of a game. The search filtering mechanism seems to work fine, so that you can quickly find games that are roughly the sort of title you're looking for. But keep in mind you need to read the description, and perhaps watch some long videos before you have a sense of what the game is about. This is essentially volunteer work, so don't expect people to be doing it continuously; just when they have some spare time and have a spot of interest.
In a couple cases, the "new" game was essentially something that I'd completed previously (one last year, the other a few years ago). The only novelty for these games was that they were now on Steam. In the case of Project Zomboid, that puppy looked quite entertaining, but it was greenlighted last autumn, but half a year later it still isn't available for sale.
Same issue with a kind of mad max rpg derby type game (name eludes me), which I'm not sure if it's even been greenlighted. Man, the derby game had a lot to it though, including long gameplay videos that took some effort to work through. Don't get me wrong. The videos were quite worthwhile for understanding the gameplay. But it's an example of the effort that evaluating a title sometimes requires.