In Germany, every club has an anthem. I'm biased towards Freiburg's as I was a season ticket holder there but Cologne (Köln) was probably my favourite. I travelled up there twice, the second time really just to hear the fans singing. It's absolutely heart-stopping when you're in the stadium. Tune v similar to Loch Lomond.
The German ones I have heard all seem to be rock style 70s anthems sung by someone who looks like his other job might be appearing in German porn (so a friend told me anyway)!