Beautiful UK tourist hotspot slammed as the world's most overrated attraction