Don't worry I'm sure you can get great tickets for $100 almost every seat in the Ralph has great sightlines.
What type of atmosphere are you looking for in a hotel ? Something in the city near more night life ? Or some place in the burbs more convienent to the stadium ? Nothing in buffalo is more than 20 mins away.