So almost certainly no one has heard of this song before, but my choice is Going Up by Coil. It's actually technically a cover of the theme tune of the 70's British sitcom "Are You Being Served?". The show is set in a department store and the theme tune lists different floors of the store and what's sold there to a pretty upbeat tune. It's a silly, camp comedy show full of double entendres and tongue in cheek humour and the theme reflects that.
Coil changed it. They took this silly song made for a comedy series about a shop and somehow transformed it into this haunting melody that sounds so ethereal and melancholic. The lyrics are the same, but made hauntingly beautiful to the point of being barely recognizable. I think it really speaks to the beauty and absurdity of death. It's mundane and fantastical and strange and normal at the same time and this song, of any song I've ever heard, captures what death means the best. The fact that the two principal members of Coil have now died, Jhon Balance before the song was released, adds to it and I won't lie it's brought me to tears before. I love this song and think it's perfect.
https://youtu.be/ztdatfUEW94?si=RTCP3yz69cAYYxeX