I can't speak much about the numerous championships that happened before my lifetime in both hockey and basketball (the hype, the satisfaction, the emotion I would have felt), but I would at this point rank the 2004 red sox #1 as I'm sure many would.
I've been able to understand the basics of baseball since I was really young. Football, on the other hand, is somewhat harder to understand as a child, IMO. For that reason, I think baseball was my first love and passion. But since early high school, I have got into football... watching hs, collegiate, and professional levels. Still, I am hard pressed to say if a win on Sunday would overtake the 2004 red sox championship.
The manner in which the red sox overcame the odds is part of the reason, coupled with the long wait older generations of fans had to wait and the appreciation that I witnessed what many had not.
Given that those odds were seemingly insurmountable, the odds against the Patriots all season long have been, perhaps, even more insurmountable. Winning 19 games in a baseball season has happened numerous times over the past 35 years (I believe the Oakland A's went the entire month of August without losing a few years back and the Rockies had a hell of a season finish and playoff run), but it has never happened in one football season. Hopefully it will happen Sunday, and then it may overtake the 2004 red sox world series championship in my own baseball-loving heart.
In addition, a win on Sunday would rank high on all-time Boston area wins because it would undoubtedly confirm that the Patriots are a dynasty even in the minds of the biggest Patriot-haters. A Super Bowl win on Sunday would also mark the final chapter in what has been nothing less than spectacular and nearly unimaginable (except in maybe Madden franchise mode)... making it perhaps one of the greatest Super Bowls ever before the game even begins, win or lose.
The manner in which the 2004 red sox won seemed perfect, but a Superbowl XLII win would prove that the Patriots completed true perfection, and that certainly would certainly be worthy of the #1 professional Boston sports team championship run of all time.
Go Patriots, make history.