The beer-drinkers’ worst-nightmare vacation cities, charted