In both Mexico and Afghanistan, it's not so much local consumption of drugs which is the problem, but production/distribution/etc. of drugs for export or transshipment.

Yemen has a drug use problem (with Khat), leading to a lack of water, etc., but that's nowhere near as serious as narco-insurgency.