Songs that are designed to accompany football tournaments/teams sort of have to be chantable, which obviously imposes limitations. Within those parameters Three Lions reigns supreme (as much as I hate the very thought of David Baddiel) and I also really like World in Motion. (Awful rap included.)
You wouldn't ever listen to these songs on your own at home, or even with other people in a non football context. But they're inhabiting some sort of genre of their own.
Funny how 7 nation army has become so ubiquitous in football, at least based on watching the euros. And again, it's not the song itself but the chantable, slightly dumb sounding riff.