I can't speak for everyone, or even to all the sports mentioned in the OP, but big hits in football are typically indicative of a good play. I don't stand up and cheer when a receiver is clobbered after a 30-yard gain. I do, however, cheer when the oposing quarterback or running back is crushed for a loss. It's not the hit, it's the result.
Thief and assassin for hire. Member in good standing of the Rogues Guild.