Before I moved back to the area, I would stay at the Red Roof in on Camp Road in Hamburg. It's definitely not the fanciest place. But it's clean, affordable, and a short ride down Southestern Blvd. to the stadium. As far as bars/restaurants, try Rodney's on Rt. 5 by the lake. It's not too far from Red Roof and they have great wings and beef on weck. You'll get a bunch of other great suggestions from others on the board, but I think Rodney's is an overlooked gem. Make sure to make hotel reservations soon, all of the hotels fill up quick.