Once a scene of desperation, the stadium became a cornerstone of the city's recovery - its revival culminating in the New Orleans Saints' 2010 Super Bowl win, a moment that told the world the city was back.