Jacksonville, for example, had no business hosting a Super Bowl. Every story I've heard from people who were down there indicates that it was probably the worst-organized Super Bowl they've ever seen.
You are right, Houston hosting last year was payback for the new stadium for the Texans. But at least Houston has a night life.