Here's a good page where you can listen to lots of them:
National Anthems Link You need Windows Media Player or similar to hear them. They are all pretty ropey MIDI versions - in my opinion, the best way to hear any national anthem is as sung by the crowds at an international rugby match.
As music, I think
Weiss Heim,
La Marseillaise, and
Nkosi Sikelel' iAfrika are about the best.
Scotland the Brave is a good one, too, although I'm never sure if that's the official anthem. It's a better song than
Flower of Scotland anway.
Some of the English patrotic songs are good - stuff like
Land of Hope and Glory or
Jerusalem. They are a bazillion times better than the tuneless dirge of the official anthem, whose wording I hate also (being an atheist and a republican, why the heck would I want God to save the Queen anyway?). I'm with Billy Connolly - the theme music from "The Archers" (a long-running BBC Radio soap about farmers) would be better, but then, almost anything would.
But the only that I like as music, AND which makes my hairs stand on end and my eyes mist up is my own -
Hen Wlad Fy Nhadau or
Land Of My Fathers to non-Cambriophones like me. (Which might explain the rugby crowd references earlier to those in the know.)
Men Of Harlech - the song the soldiers sing in the film
Zulu, comes a close second.