Whilst you may get the impression that the coffee shops are only for tourists, the Dutch definitely enjoy the occasional joint.
The Coffeeshops are still something that pique the interest of tourists. They were one of the first places you could buy weed and hash without running the risk of getting arrested in the world! (No, they are not legal, just decriminalised).
There are coffee shops not only in the tourist hotspots of Amsterdam, but in all cities and most small towns in the Netherlands. Coffee shops don’t sell alcohol, or offer hard drugs. Those are as illegal in the Netherlands as any other country.