I like to think that Barcelona is a good example of how Olympic Games should impact a city. Growth was controlled and it allowed for regeneration of some shady parts of the city. They didn't build crazy venues and the ones they did build are still in use today 25 years later.