I lived in Noe Valley for 14 years in a rent controlled apartment that quadrupled in value during that time. I was eventually evicted with an owner move-in but during that period I saw all of the useful local businesses close and be replaced with ...
1. Doctor/Dentist offices
2. Real-estate agencies
3. Banking and financial institutions
3. Doomed boutiques riding off the areas old reputation - these always closed within 6 months.
4. Expensive date restaurants or bars serving just enough food to count as a restaurant.
Off the top of my head, we lost the newspaper/magazine shop, hardware store, a few cheap restaurants, the glass blowing shop, the running store, a bunch of nice boutiques, the local butcher and most (but not all) of the businesses that made someone want to live in Noe in the first place. We gained a ton of financial and real-estate frontage (useless for day-to-day life) a couple of nice but expensive upgrades like a Whole Foods. All this money and no-one seems to actually spend it on local business, so nothing stays open for long.