I honestly believe that other than actually winning the Super Bowl, there's no better time for an NFL fanbase than the first years of a team having a young QB that looks like they might be "the guy" of the future
I'd argue it's even better than being a perennial playoff powerhouse or a team that continually is seen as a favorite
Less stress. If you're a true contender with an experienced QB, every loss kills you. If you lose with a young QB doing something idiotic but they put up 300 yards and 3 TDs, you still leave the game optimistic. I call this the Josh Allen. I definitely feel like the Bills fanbase were happier two years ago when Allen was breaking out compared to now when he's seen as a star QB who should be leading the Bills to the Super Bowl.
My cousin's Jewish rec league flag football championship had more fans in the stands than this game by the 3rd quarter