I’m just flicking through my iTunes here and in truth most singers attempt to put some sort of narrative into at least some of their songs.
Hole In The River by Crowded House - Because it was inspired by, and describes, the real life suicide of the song writer’s aunt. Tries to be celebratory rather than maudlin. Crowded House also have Mean To Me inspired by an obsessed American fan flying to New Zealand to meet the band.
Cloudbusting by Kate Bush - Not a clear narrative but inspired by a real person (psychologist and philosopher Wilhelm Reich) and because it has the first line “I still dream of Orgonon” and Orgonon is a word I had never heard used in a song before or since.
Family Snapshot by Peter Gabriel - Gets into the mind of Lee Harvey Oswald as he prepares to assassinate JFK. More of a narrative to the song than, for example, Gabriel’s Biko which is based on the real murder (in a South African jail by the authorities) of Steve Biko.
Man On The Moon by REM - The song about American comedian Andy Kaufman and as a narrative isn’t particularly clear. But nor was Kaufman. It went on to help inspire a biographical film and - this is only my opinion - I reckon the song tells you more about Kaufman than the film.
Bodies by Sex Pistols - Inspired by a mentally ill female fan of the infamous punk rock band and her rapes and abortions. Noteworthy - in the context of being a narrative song - by it’s extremely visceral nature. Musically, lyrically and every way you can imagine violent, aggressive and spewing out loathing. Very much NSFW if you choose to look it up. Unlike much of the extreme, thrash and hardcore music it inspired, the lyrics are pretty easy to make out.
But there are so many songs and artists I could have mentioned.
Elvis Costello does narrative and social commentary in his songs so well. Elton John in the early days. Dire Straights. Tracey Chapman. (British Band) Stereophonics. A few Rush songs.
(British Band) Pulp base a lot of their stuff on real events and people - I really should have included Common People or Disco 2000. Disco 2000 was the singer (Jarvis Cocker) reminiscing about a real girl he platonically knew as a child before he was famous and wondering, in song form, whether he should try to meet her again at a Millennium Party - the song written in 1995. Rather sadly to anyone who knows and enjoys the song, in real life, his muse (who married, had kids, became a dedicated nurse) died of cancer in 2014.
The Tubeway Army (Gary Numan) album Replicas is fantastically evocative of a specific kind of Science Fiction - Philip K Dick for example - and I simply love listening and falling into that world but I must admit no single song has much of a specific narrative to it. But the mood it creates. Are Friends Electric is a stunning piece as are Down in the Park, You Are In My Vision, Me, I Disconnect From You… Tying into the OP, Gary Numan apparently created themes and ideas for a novel before abandoning that and converting the lyrics to songs.
TCMF-2L