NIMBYs tend to welcome things that aren't new housing since they are likely to raise their property value. New housing has the potential to do the opposite.
You’re also overstating the support from “local residents”: the fact is that the city council gave a prime plot of redevelopable land (in a city with little available) to a sports team, as part of a sweetheart tax deal. It’s a criminal misappropriation of resources that was made behind closed doors.
Not sure what closed doors you're talking about.
The Warriors stadium is literally a gold standard and a model that other sports teams should follow. Not only did they pay out of pocket, but they donated millions to the city to help manage traffic in the area.
Pacific Bell Park was wholly privately financed, much of that from seat licenses. And the ballpark was key to the redevelopment of the entire China Basin area -- look at aerial photographs of the region before 1999.
There's nothing wrong with building entertainment venues in cities if they're financed without tax payer money.