What about Codeine? It's an over the counter drug here, and heavily restricted, if not banned in UAE. How do you get a prescription for that?
Drugs in Dubai
People have been arrested in Dubai for possession of Codeine:
Dubai tourists warned over tough drug stance - Middle East - World - The Independent
That said, I know the rules and would never take anything there. I do wonder about the general travelling public though. Of course, Dubai is now a big tourist destination, particularly for those in Europe and news of any issues is extremely rare (the case above was in 2005).
As the the xenophobia, the UAE has a lower crime rate than either Thailand or Malaysia, the US and even (wait for it), Australia. Not sure what the issues are with that. I've travelled extensively in the middle east including to the UAE, Syria, Bahrain, Jordon and must say I felt less safe in Bangkok than any of them.