I live in the Seattle area, which is struggling with public drug use just like Portland. Like Portland, we've lived for decades with very progressive politicians who have lead successful decriminalization efforts and spent huge sums of public funds on treatment and harm reduction programs. After several decades and many, many millions of dollars spent, the problem is, by every measure, absolutely the worst it's ever…
Unfortunately we still have a large portion of the population who believe that one must deserve to live a dignified life, and then apply all sorts of caveats on who is deserving. So we can't reshape the economy to support everyone because the people at the top need to feel like the work they did to get there somehow speaks to their character rather than merely their circumstances. They can't accept that they're not actually that special and so have some pathological need to draw lines between "us" and "them" (e.g. "taxpayer" vs "freeloader").