Nicely put, I have pondered whether it would be more fun to be a fan of a team with modest expectations. I went to an Ole Miss game a few years back and they explained to me how they had fun win or lose (and they indeed did), and a Bama fan was at that particular tailgate and she explained that Bama fans almost never have fun because they are so stressed about not only winning, but winning BIG.
If I could choose, I'd have been a Kansas State fan back in the Snyder days. A bowl game was a good year.
I find there's some of this dichotomy between being a fan of Purdue football and Purdue basketball.
In football, we know we're a low-end P5 team. We know our recruiting is, at best, mid-tier B1G on a good year. We celebrated our 2019 class, ranked 25th in the nation and 4th in the B1G, like it was the best class Purdue had ever signed, because it is pretty close to being that. A mid-tier bowl game is a good year, and all rational fans recognize that. Going to a Rose Bowl is a generational treat.
In basketball, the stakes and the expectations are SO much higher. We expect to be competitive in recruiting battles with every team not named Kentucky, Duke, or UNC. That means we don't think we should be losing recruits to MSU or IU, either. We expect to be in the B1G championship race yearly. We expect to be like the Bo Ryan Wisconsin years, where finishing outside the top 4 in the conference is cause for concern. We expect that making the tournament is a minimally acceptable year, but a "good" year is a top 4 seed in the tournament and a Sweet 16 or better.
Fans are thankful for the AD opening up the pocketbook for Brohm, and would be willing to build statues for coaches like Joe Tiller. Some fans, at least up until last year, were ambivalent about whether Painter should be retained because they claimed his "ceiling" was the Sweet 16 and were generally termed the "demand better" crowd because they thought Painter would never reach the "next level".
I'd say being a Georgia fan is similar, except that I honestly think most SEC programs don't give a damn about their basketball teams. For the SEC, it's all football all the time unless you're Kentucky [and maybe Florida?]. I think most SEC basketball fans, if your team is making the tournament at a regular clip, are plenty happy with basketball.