To me, it's about the quality of the ideas and not necessarily the package they are wrapped up in or who it comes from.
There are plenty of good, interesting and original published settings out there. As Etarnon said, I generally look into a setting and decide if its ideas intrigue me enough to want to buy it.
Even with prepublished settings, it's very rare that I adopt them whole-cloth without ending up injecting some of my own twists and ideas into them. That's not because the settings are bad, often quite the opposite, but just because I like to be creative and involved as a GM and want to take ownership of the campaign. In fact, a really good setting should often get you excited to create your own home-brewed ideas within it. A good setting is the springboard for your imagination.
I've also played in home-brew settings before and some of them were quite fun. In most cases, they were often inspired themselves by other settings, movies, books, etc.
I recommend people to play settings that interest them regardless of where they come from. If you restrict yourself to "only mass-published" or "only home-brew", you are really missing out on a lot of what makes RPGs so unique. Also consider settings/games from different companies. Again, there's a lot of good stuff out there if you're willing to broaden your horizons.
HARRY DRESDEN — WIZARD
Lost items found. Paranormal Investigations.
Consulting. Advice. Reasonable Rates.
No Love Potions, Endless Purses, or Other Entertainment.