Depends on your taste and budget.

I've been based in DTW and CVG both. I would say hotels are a bit pricier in CVG and can be harder to get. Depends too if you have a car.

If you have a car, try Priceline in the airport and Florence areas. Generally, a $50-55 will get you a 3 star hotel out the door for under $70 after taxes. The Doubletree at the airport gives us $76 out the door and it is very nice. This is almost the best bet for value for your money.

There are certainly dives that can be had for cheap. I think that the Quality and Comfort Inns are in the $45-50 range out the door. They aren't great, but if you aren't going to be there long I guess they are tolerable.

Country Inns and Suites is about $68-70 out the door, but seems to always be full. As dead as the airport is, (good) hotels can be tough to come by.