Most miserable song? "I am stretched on your grave" is fairly grim, and "Carrick Fergus" quite thoroughly depressing. Anything by Leonard Cohen has to be in with a shot. Cheerful songs? That's even harder. No, can't think of any.