My question isn't about how visible drug addiction is but any actual metrics that can compare actual drug addiction rates and prevalence between places with decriminalization and those without.

Because just some cursory googling suggests that these cities do have less incidence of drug addiction/use per capita. But I don't really know how accurate that info is, and anecdata doesn't count.