San Francisco had the “very local area benefits” phenomenon when they built AT&T Park. There was one sports bar a few blocks away that had somehow slipped through the “friends of the mayor are supposed to buy up all the good properties and Alcoholic Beverages Commission licenses for sports bars before construction starts” policy.
But in fact the area from the park has benefited quite a bit as far as housing stock and tourism since then, a lot of it from zoning changes, but it’s pretty much all been yuppie housing, not high-density affordable housing taking advantage of nearby transit, though that’s somewhat mitigated by the short walking distances to the financial district and SoMa / Multimedia Gulch areas.
