Here is an idea- rent an rv and get the full tailgate experience? If not I would stay downtown- nothing is really far from any place that you pick- Marriot and Hyatt would be a good choice. You can also consider East Aurora- a cozy town with good restaurants/bars right on Main Street and its a quick trip to the stadium- ten minutes.
Lastly- people mention Chippewa- stay away unless your idea of a good time is getting mugged. Hit Elmwood strip or Hertel Ave if staying in the city.
I really hope this helps!
We are definitely getting an RV one of these years, but my vote hasn't carried enough weight for us to do it yet. This is all extremely helpful. Thank you.