I think this works fantastic in Capitol Hill neighborhood in Seattle. The ground floor is filled with restaurants, cafes, bars, retailers that define the neighborhood as a cool part of town. There is enough public transportation, grocery stores, and other amenities that it creates a walkable community (a rarity in North America).
The area has downsides, but it is doing well economically.
The area has downsides, but it is doing well economically.