Jim Malcolm (formerly of Old Blind Dogs) wrote a couple of Edinburgh songs that I like: "Losin' Auld Reekie" and "Flowers of Edinburgh." "Flowers" is about a spot in front of the cathedral on the Royal Mile, where people spit on the pavement for some reason....

Oh, well, it loses something in the translation.
If you like singer-songwriter songs (I have mixed feelings), Jim does some pretty good ones (and he's a really nice person to go on a tour of Scotland with).
-Joe-