https://www.youtube.com/watch?v=Hesv3K4Dz9M (uploaded 12 years ago, but I couldn't find it for a long time and only looked again recently - whilst looking for Faith no More's song of the same name).
Another was the song Purple, for which the commonly shared MP3 was mislabelled as by the band Air. Turns out it was a band called Crustation, who released a single magnificent trip-hop album, with Irish vocalist Bronagh Slevin, and then disappeared into the ether. Took me a few sessions over a few years to track all that down.
https://www.youtube.com/watch?v=yKNJCVruRLc
Another one was a song that got high rotation for a very brief period of time (when I was on a driving holiday, and so had the radio on a lot) maybe on Triple J, early 2000s, called Media Junkies by the band of the same name. Turns out the song was actually called News Addiction. One hit wonder.
https://www.youtube.com/watch?v=IyZxYopvowA
The last remaining splinter (that I can recall) is a song from the mid-90s, "eager beaver" or "tenfour" or some variation on that features heavily in the lyrics as truckers chatting over CB radios. Haven't done a search session in a number of years on that one, but never got anything close to a lead on previous attempts. Maybe it's time to have another go.
Way back then, it was the research that was at least part of the enjoyment. I think it taught me how to research, to some degree at least. I went from Faith No More to Mr Bungle, and back then it wasn't easy to find this kind of stuff. Mr Bungle then changed my entire future musical taste journey. Good times. Worth the effort.