Some people think that hosting major sporting events brings little long-term benefit to a city.