I'll add two:
(1) Daytona 500. Regardless of whether you like NASCAR or not, the atmosphere is electric. It is awesome.
(2) Glasgow Rangers v. Glasgow Celtic in soccer. The passion behind religious differences is channeled through to the soccer field, and the entire city is on edge.