Lake Placid,NY has done a beautiful job-——real tourist attractions.
.
Brazil, where the nuts come from.
I think LA also did well facilities wise in 1984 since they they had suitable facilities already available for most sports.
Some oddball things like small stadiums for beach volleyball, or baseball fields in countries that don't play baseball might be hard to use in the future, but there seems to be little excuse for building outdoor stadiums and indoor arenas that can't be used after the Olympics are over.
I know many people that go to Lake Placid to ski Whiteface. Lots of them love the experience of a trip down the bobsled run too.
Of course, Lake Placid was a winter tourist destination before the Olympics ever came there.