the main market for the coffee shops turns out to be drug
  tourists from abroad

That's not true. Although a number of coffee shops in Amsterdam and in cities close to the borders with Germany and Belgium primarily sell to tourists, there are many more coffeeshops that just sell to the local users.