I think the decentralized/layered structure of American government is great, because as you said, it allows smaller polities to test out new ideas before growing to a larger scale. I haven't heard of that phenomenon where people migrate to a new city in pursuit of the substance, and that could definitely be a valid issue.
What makes them "undesirable" though? Are they not contributing to the local economy or something else? I don't think it's a problem intrinsically linked to substance decriminalization, and might even be a benefit of decentralized government. Delaware's lax incorporation laws, for instance, encourage people to do business there, which benefits the state.