FWIW the Chase Center is 100% privately financed. SF is actually benefitting from private investment into public transportation to/from the arena. Public housing is great, but it’s not like the city chose this instead of that.
Remember, people often have limited understanding of impacts focusing on a small percentage of what’s going on. Aka sound byte politics, a stadium is only half the story rarely used, low density parking can be a larger issue.