Not really an equivalent scenario. If all you want to do is get drunk, there's no reason to go to Napa to do it, so while the average level of intoxication is probably higher, it's much less so that it would be if it was the only place you could legally buy alcohol.
It's not just a few coffee shops, Colorado and Washington are big states. They will very much welcome tourism and the dollars that brings in. The cannabis cup was already in Denver and I don't recall hearing complaints about all the money it brought to Colorado.
