I think if you had gaming on-site slots, poker, sport betting it would work for at least 22-30 weekends a year once you factor in a few concerts, festivals etc. One reason I haven't been back after living in S.FL is its cheap to see them play in Miami, family friendly environment and the kids can hang in the lounge with the wife without worry. In Buffalo a hotel and entertainment then my wife would be happy to stay in the room watch from above and the kids play or watch tv maybe come down for half the game.
Coming to buffalo now you have crappy hotel options near the stadium, crappy family environment at the game and not so great weather. So if you are going to pull in those families you need better amenities and lodging. Drunk college kids aren't going to spend the money a Dad will with 2-3 kids and wife in tow at the venue and in the town.