With Amsterdam taking aim at disorderly Brits, we discover where else has a difficult relationship with visitors