i lived in troy for 5 years.
franklin square is the closest, it used to be a super 8, it\'s about 3 blocks away.
the rensselaer inn is a little further, but it might be cheaper. i\'d go with franklin square.
that\'s it for hotels in downtown troy. don\'t go ANYWHERE north of rev hall unless you are looking for crack.
try the cherry raspberry ale, VERY yummy. the food at the brewing company (that they are connected to) is so-so. beer is great.
there\'s an awesome pizza place on 4th and state called i *heart* ny pizza, and it will be open until 4:30-5am after the show for late night munchies, it\'s like $1-2 for a slice and a soda.
if the show is over early, you can all head over to a bar called the ruck on 3rd and state (about 4-5 blcoks from the hotel, it\'s safe, all college kids go there), bars are open til 4-4:30am there.
also, troy is a giant mess of one way streets so be careful when driving around.
have fun