What cities have or haven't benefitted from hosting the Olympics?

For example, Vancouver didn’t have to build most of it’s venues for this Olympics. But take for example Greece or China had to build a majority of them. (Of course summer games are different than winter ones, so they might need more)

But I remember reading this article a while back how Greece didn’t really make up it’s investment in the games, and how the venues they created are not being used much or even kept up.

I think it will be good for Vancouver, since it was more like a giant renovation project. It could help infrastructure, increase tourism, and show others it’s a nice place to live.

So which cities flourished after the Olympics?
And which floundered? Why?
What’s happening with the old venues?