With the death of Leonard Cohen, Jack Ashworth shows us the songs that have looked at the passage into ‘that great gig in the sky’ with more nuance