I just saw my Houston Cougars win the conference championship this year. I know it's not the national championship, but it's the farthest a middle of the road team is gonna get any time soon. I've been a fan since I moved here five years ago, it was exciting, but not as exciting as the Bills/Sabres winning it all one glorious day. Probably because it's a mediocre championship at best, I didn't go to the school, and I didn't grow up with the team and became a fan when I was about 20.
Also, I was there when the Bisons won the Governor's Cup in 2004. I know that's minor league, but I was a huge fan, went to about 15-20 games a year, and even watched a lot of games online, so it felt major to me.