X-country skiing, guy falls down at the start of the race (tangled up with others on the starting line), breaking a ski, he's dead last, everyone counts him out, and suddenly at the end of the race there he is, pulling up on the leaders like a freight train, to win the silver.
I'm not a big sports fan in general, but moments like those are awesome.