I'm sure it's a financial windfall for the city and all the vendors though, but the city has to be prepared for it. Some cities handle it better.
Indy is a perfect example of what proper planning can do. There are two major races here every year where 200-300k people come to town. They get in and out of the facility easily. There's plenty of hotels, shops, restaurants around to handle that crowd. Indy's Superbowl a few years ago had the highest rating of any SB in terms of customer satisfaction.
I like Cincy, it's clean, modern, friendly, and has a cool history. That view of the city when going north on why 75 is awesome. We usually get over there a couple times a year for a Reds game, King's Island, or the Newport night scene.