Wil, nice thought, but actually your thinking is faulty. The cities with less partying and less tourism are the big winners. I will go into a somewhat long reasoning:
The math for these problems is extremely dubious. I worked on a committee in San Diego that tried to determine the value back after the 1998 game held at Qualcomm Stadium. We came up with something like 23 or 25 different numbers. We had economists, businessmen, city council members, the Mayor's office, the Governor's office, and a cast of others trying to get their views in. We had people who wanted a library built that practically filibustered one of our meetings. It was a joke.
End of the discussion we came up with math that true value to a city such as San Diego is probably about $80 million. There was a surprising and somewhat controversial conclusion though. Much of that value is driven by future visits, not the stuff that goes on during the given week. Most studies proved that while it is a nice draw to a town, a place like San Diego which is about 90% capacity during January due to conventions and premium weather loses a lot of business. I suspect New Orleans isn't quite as crowded in January, but I am sure they are closer in effect to San Diego than Jacksonville. With hotels booked or gouging customers, it chases away a lot of people who contribute to the city in more valuable ways than the SB does. Part of the secret is how much of the money spent during the week goes to people who don't live in the area. Souvenir vendors, ticket scalpers, tons of transport people driving in from all over the West (limos and buses by the thousands from LA area), the NFL Experience and the NFL itself benefit greatly and then take their money elsewhere. Lots of businesses come to town to network and do business, but they are visitors all around making deals with each other.
When it came down to it the whole math showed maybe $20-25 million in positive benefit from the weekend alone due to increased money left in the economy over a base weekend. Note the stats may say almost $200 million or more in revenues from the weekend, but once again that is offset by revenue that didn't come in. San Diego normally has conventions that do better business. The real value though, pegged at about $50 million, is that for one it is a big free advertisement. The city has had three Super Bowls all played in glorious 60-70 degree sunny weather which yields future visits. Second it draws repeat visits from visitors for the game who say "I have to come back again" but would never have visited in the first place. Third a modest amount of value is added to the prestige of having hosted a game. I believe above all else Jax is really banking on this. Not a big deal in SD, but I could see it being of more value to a city that few ever think of as a tourism destination. Lastly the city paid a lot of money in guarantees and construction costs for the stadium, which were partially earned back by the game through increased ticket sales. A Chargers official guessed 2,500 extra season tickets sold because of the SB ticket lottery the team held. We didn't take his word for it, but we assumed 500 extra tickets sold, tickets that the city would have paid for in about half the games that year that didn't sell out.
Is that a convoluted enough answer? I tell you I could go on, but it is a total mess. Very fuzzy math, but just like the arguments for building a stadium. You can make the numbers say whatever you want really, but the conclusion really was other cities probably gain a lot more from it and it wasn't likely worth it to expand the stadium any more as the NFL sort of demanded to get more games sent to SD. In the end the NFL couldn't argue with how much everyone loved the city as a venue so it will continue sending the games about every 5 or 6 years as long as the Chargers are still playing in the city.