Sydney did pretty damn good out of it (and it still is).
It is intended that the public spending required by the Games will revitalise some of the run down parts of London and its public transport system. There can be some economic benefits to the Games; however, this will be tricky to manage properly.
Regards, Ivan