Visible in every skyline shot of New Orleans, the Superdome has cemented itself in New Orleans history as a place of joy and pain.