@bmeelneg:

The Redsox 2004 Championship WAS a "Nationwide Holy Crap! Moment"

It was the first time a team has comeback from 0-3 in over 100 years of Major League baseball. I'd say that qualifies.