Two new stories attempt to answer this question, with input and photos from The Olympic City project:
Salon.com:
Sochi’s bleak future: What happens to Olympic cities after the Olympics are over?
Today.com
What happens to Olympic venues after the torch goes out?