Lazarus by the Boo Radleys. The second I saw this thread it came straight into my head, I can't think of anything else that even comes close. A Velikonja of a song but an absolute Macheda of a video. What were they thinking?
https://www.youtube.com/watch?v=6gZB1J7ejhA