Tournament travel fuels local economies but puts real pressure on host cities managing crowds, infrastructure and costs.