"Mer Losse d'r Dom en Kölle" (Cologne Carnival song) and our own McGrath of Harlow's beautiful, "Green Heart of Harlow" spring to mind.
One day someone will write a ditty about Callington in Cornwall. So far no one has been so inspired to my knowledge. They say that it is so dull there that the taxi drivers are safe, because there is nowhere worth driving to in a hurry!