The Hyatt Place mentioned on the last page is a great value. We stayed at the one in Grandview right next to Buckeye Grill. They shuttle you from the hotel to Champps @ Lenox for free. Our driver mentioned they do offer transportation after the game, however I can not verify that is correct. I may have had too many adult beverages.
As for the Blackwell, I have stayed there about 3-4 times during a football weekend. Yes that is where the players stay on Friday night. During one stay, one of the players actually knocked on our hotel door, trying to wake us up on Saturday. My wife said he was very confused/surprised when she opened the door. The trick with the Blackwell is to wait until the week of the game. Most times rooms become available Thursday on hotels.com. Now its not cheap, by CBUS standards, however the convenience of being that close is priceless.