This doesn't really have to do with yes-men. We're not talking about people who feel negatively about your company, but rather the fact that you run one at all. The kind of scorn the article author talks about is not "oh man, there's no future in (field)", but rather "why in the world would you risk running your own company?!". The latter certainly still calls for a thick skin, but it would help if your closest friends and family were supportive about the concept.
In theory, yes it's true that scorn may even help one's entrepreneurial flame. The difference is that starting a company is like starting a fire. Little gusts of wind can buttress and make the fire spread, but it can also knock it out.
Having the support of the community within the bay area is just one less headache to deal with in conjunction with the many headaches of doing a startup.
If you compare one place to another, and clearly one of those locations has an environment more supportive for success in your field, wouldn't that be preferred? Perhaps you are just looking for a challenge, but if you're like the rest of us who are looking to succeed, maximizing the success factors tends to be a good idea.
