I picked this topic up from the SFI chat this afternoon. I am a New Orleans Saints fan and and have witnessed that the song Halftime by the Ying Yang Twins, gets the place rocking. I suggested this for hockey a few years ago and was pretty much told to shove off. After I thought about, I agreed. It doesn't translate to hockey.
Having a football stadium full of people dancing and yelling "Here we come to get you",though, works.
Flame away and/or come up with something better.