Through Super Bowl XLIV, that is Cleveland. Houston (Texans), Detroit (Lions), and Jacksonville (Jaguars) have hosted a Super Bowl but not played in one.
List of "cold" weather cities that have hosted the Super Bowl: Pontiac, Michigan - Pontiac Silverdome - Super Bowl XVI - Jan 24, 1982 Minneapolis, Minnesota - Metrodome - Super Bowl XXVI - Jan 26, 1992 Detroit, Michigan - Ford Field - Super Bowl XL - Feb 5, 2006
Both Miami and New Orleans have hosted 10 Super Bowls.
Since the game is awarded to a city four years in advance, there is no way of knowing how good that city's team will be. They will play the game as scheduled.
Super Bowl 4.
As of Super Bowl XLII, no city has hosted the Super Bowl 8 times. New Orleans has hosted 9. Miami (and Miami Gardens) has hosted 9, and Los Angeles (and Pasadena) have hosted 7.
Wouldn't it make more sense to look up the cities that HAVE hosted a Super Bowl?
No. No team whose city has hosted the Super Bowl made the big game that year.
the answer is San Diego.
Buffalo for one.