I have no real interest in either the Giants or the Patriots, and that was still pretty much the best superbowl I can remember watching. Super close, tense game the whole time, perfect season at stake, back & forth lead changes, a final drive and winning touchdown with only seconds to go.. I don't know what more you could really ask for.
Except maybe your team of choice being the one doing the winning.