Do you count the influx of homeless as residents? These people absolutely need healthcare, but they are a resource drain that can move in suddenly, unpredictably, and overwhelm a local solution with static resources.
Then you get a situation where the wealthy, even (and sometimes especially) the diehard leftists who voted for the situation, turn up their nose at what’s shown up in their backyard, and fuck off from California to Colorado or Texas. This reduces the tax resource pool, stressing the residents and businesses that can’t afford to leave further. This creates resentment.
Coupled with the overly dramatic and personal shitshow that is local politics, frankly I see local initiatives as a fantastic way to fail tens of thousands of times.
Fixes have to take place at least at the state level, and even that is less than ideal, because expenses have to be spread out (especially in regards to the wealthiest 1% that pay a huge chunk of income tax, and are not equally distributed across local towns) without creating an attractive hotspots for tax resource competition.