Cincy actually has alot of fun things to do and can be very pretty especially during the Holidays. Take it from someone that actually lives here. (Ice skating on the square, carriage rides, train display, etc) There are plenty of hotels to stay in downtown with lots of nightlife and it's actually safe to walk in alot of areas at night. It is more expensive to stay there than the suburbs of course. You can also check out Northern KY which is just across the bridge from the stadium.
There is a GREAT Steeler bar North on 71 in Clifton called Martinos. Big game days you can plan on 200 plus Steeler faithful.....plenty of reasons to have a good time in Cincy. Yes the Bungle fans can be obnoxious but I've found that for the most part your attitude can have alot of influence on that. Remember, there are idiots in every fan base.
If I can be of any help, I'd be happy to. Hope you enjoy your visit here. Rest assured that there will be plenty of us waving our towels with you...there always are. WE DEY!!!!!!