The Transatlantic Anthology of Hamish Imlach has several funny songs, for me most notably the coppers' song and including the Dundee cat. It also has one which I knew as a joke for years before I ever heard as a song "I was a Gay Spark in my Time".

This was the subect of a previous thread but as far as I can see the words never made it into the DT, despite being in the thread.

previous thread