Here are some fascinating photos of Olympic sites, after the games. You'd expect some of them to fall into disrepair after some time but it happens surprisingly quickly. Many of the sites are single use only and after the games stop, that use goes away. The kayak section in Beijing is a perfect example.
Any cities that bid on the games should keep pictures like this firmly in mind.