The Olympics in London went far better than anyone expected, but TBH it only benefited a small number of actual Londoners and they are the ones who paid for it. We didn’t even have preferential access to tickets, even last-minute tickets - it was actually more difficult for Londoners to get tickets than for people in other countries.
The swimming venue is the best managed because it’s now a GLL swimming pool, meaning you can just go and swim there at the same rate as most other swimming pools. The other main stadium was relatively well-managed in that the seating was designed so that some of it was temporary and it’s now been sold to a football club that can cope with that the security, etc requirements for the seating that’s left (they couldn’t have for the existing Olympic seating). The main problem with that is that the football club (West Ham) got it for much less than they’d have paid to build a new stadium because, since it was already a sports stadium in the East End, they were in a buyers’ market.
I’m pretty sure some of the other facilities are also used for sport. None are being left empty, that’s for certain.
The Olympic Park is now a venue which is used for various things, such as a current faux seaside. That’s far, far better than leaving it empty, but the problem is that you still have to pay theme park rates to get in, and local residents are still having to pay for the upkeep.
It’s also, oddly, not that good when it comes to public transport. If you look on a map it might look good because Stratford station is right next to the park, but that’s just the entrance to the park. There’s an awful lot of space between there and anything that’s actually happening; you trudge along a long pedestrian pathway for about half a kilometre. No roads for cars or busses, so if you have a mobility problem or small children it’s really quite difficult to access.
Many local residents were displaced due to this Olympics, and it was built on sites known for their wildlife. None of them have seen any advantage.
And that’s for an Olympics that I think was enjoyable and was as well managed as it could possibly be. It still meant, and will always mean, local communities losing out for the sake of the prestige that they’re unlikely to get a nibble of. Rotating between a few cities would definitely be a better idea.