Hmmm. I think I want to be surrounded by an entrepreneurial culture. I’m libertarian culturally. I don’t like dumb. Or snooty. But I can deal with a wide variety of both.
On a second thought, you might have fun with the fancy markets. The best entrepreneurial culture in the US are really at the major tech hubs (SF, NYC, LA, and secondarily Boston and Seattle). You'll def meet more people in these locations than in Charlotte, NC. Austin is a good thought but I suspect you'll get bored, because let's be honest, people who move to Austin are all of a certain type.
I've also noticed that big markets are much more libertarian fiscally. Yes, taxes are high, but private opportunities are much more plentiful (what they call "the startup ecosystem"). In smaller places, if you are a consultant (either clinical or not), often your options (referral sources) are limited to large non-profits and government agencies. A different way to say this is in large markets, if you are bored with cash private practice there are lots of other fun things to do that are not available in smaller, "more affordable" markets.
W.r.t. cost of living, yes, Palo Alto will bankrupt you. Have you seen the latest 3M house sold? It looks like a pile of garbage on Redfin. *HOWEVER*, in large markets, you can almost ALWAYS find areas where things are much more reasonable. You'll have longer commutes, but if you are private practice, you can easily structure your day in a more reasonable way--come in 2-3 long days a week, for example, and telecommute the rest of the time. People obsess about geographical arbitrage, but they don't get that within a single metropolitan area, there's also "time arbitrage". Cost of living is wildly different between parts of Queens and Tribeca, even though in both cases the local public schools are rated 10/10. Just some food for your thought.
I would suggest looking into peripheral parts of major markets (for example Vallejo up to wine country, and upper Hudson Valley, parts of lower Orange County, etc.). You can sort of fabricate an Austin-ish experience but end up with more.