The issue I see is that everyone wants domes so they can host the super bowl (and monster truck rallies or whatever but mostly the SUPER BOWL!) However if every team has a dome and the NFL is equitable and doesn’t just say ‘f-you, cleveland. we are going with New Orleans, Vegas, and Dallas every year’ then you get one super bowl every 32 years. The economics of it seem off.
LA, New Orleans, Dallas, Miami and Vegas. There you have it. You have a permanent rotation there. Every 6th year, it should be when the team builds their domed stadium, they get to host it once. Indy and Detroit. But that's it. No repeats.
I remember Super Bowls being played in Detroit and Minnesota. I also note that the NFL has not been back to those locations either. No one but the respective fans of the participants wants to attend a Super Bowl in the north. Charlotte would be borderline. The one year Jacksonville hosted it was ridiculed as a one-horse town unsuited for hosting such a world-level event. Dallas (Jerry World) and LA have set new standards for stadiums. Everyone see wants to keep up.