There are many articles about abandoned Olympic venues but I've never seen one about successful former Olympic venues. I'd like to see what happened to all the venues in London and Beijing. From my bit of knowledge a lot of the London ones were temporary or have been successfully transitioned.
However, it was overwhelmingly a successful Games. It created a lasted economic boom, and much of the construction saw continued use or was repurposed afterward.
Today, Atlanta is not really remembered as a "bad" Olympics (because international sports organizatinos like the IOC and FIFA have become more disgustingly capitalistic than we ever were). We are likewise not really remembered as an "success" story either, frankly because most cultural commentary prefers not to think about southern American cities at all outside the context of sweeping generalizations about racism (1). But quietly, it was an example of a success story for the host city.
(1) Yeah, between the '96 Games and this year's Super Bowl, Atlanta sports fans are a pretty bitter crowd. Don't mind us!