It will be interesting to see how Steam Greenlight pans out. I expect everyone to thumbs up the mods and maybe Valve will put more mods.
Right now trying to sort through the crap to find anything interesting is taking more effort than it should, but I am sure Valve will improve on it. The curated collections are a decent start. (Thanks ad_hominem for adding Recruits to your collection!)