Do Cities Benefit From Hosting the Super Bowl?

Super Bowl LIX will be hosted in New Orleans once more, a product of a competitive bidding process that chose an NFL favorite. Is it worth it for cities to bid for the right to host the Super Bowl?