Fodor's Travel warns Brits to rethink trips to major holiday hotspots as over-tourism is causing them to "die of success".