I would strongly recommend the Sheraton, but book it as soon as possible since it does fill up for games, and I would be surprised not to see a 30,000+ crowd for the UConn game. Of course there's Dinosaur BBQ, and really everyone visiting Syracuse has to go there. For pre-game festivities check out Faegan's. It's a short walk from the Sheraton and the Carrier Dome on the SU Hill. It's got a great beer selection and is the 21+ bar on the Hill, so you wont be partying with freshmen girls. I'm also always shocked at how cheap things are in Syracuse. Last time I was there (2 years ago) there was $3 pints of Magic Hat. If drinking with freshmen girls is your scene, any of the other Marshall Street bars will do.
If you have time, I would also strongly recommend Rosalie's in Skaneateles. It's about a 1/2 hour drive from Syracuse, but is worth it.
Armory Square has some good bars and restaurants as well, but it's been almost four years since I've spent any time down there.
Enjoy your trip to Syracuse, it isn't nearly as decrepit a city as people say. The Dome is a really neat place to watch a basketball game, and unlike for football, it offers a pretty fun fan and game day experience.
I'm really looking forward to our games with Connecticut this year. UConn is going to be a great team come February and I hope we can at least take one from you.