Date Rape by Sublime has a plot… and it’s pretty funny.
Ah, but don’t forget Cream’s over-cockneyed Mother’s Lament. Some of you have heard that my twisted little toddlers HAD to have it sung in the tub each night:
A muvver was warshing her bayby one night,
The youngest of ten and a delicate mite.
The muvver was poor and the baby was thin,
'Twas naught but an skellingtin covered with skin.
[snip]
And, yes, the immoral anklebiters always giggled at the part:
Ohhh, your bayby has gone down the plug 'ole.
Oh, your bayby has gone down the plug.
The poor little thing was so skinny and thin,
He should 'ave been washed in a jug (in a juuuug…)
…
Kinda depends on how you define ‘plot’, too; if you count “boy meets girl” as a plot then every other song has a plot.
Dylan has quite a few, as well as the aforementioned Lily, Rosemary and the Jack of Hearts and Tangled up in Blue, you could also add Black Diamond Bay, Changing of the Guards, most of his “Ballad of…” songs, Who Killed Davy Moore, The Lonesome Death of Hattie Carroll and about a billion more.
Most songs from The Alan Parsons Project’s Tales of Mystery and Imagination also do, being based on Poe stories.
House of the Rising Sun.
Black Sabbath have one or two; The Wizard and Iron Man spring to mind.
The Clash have Rock the Casbah, Spanish Bombs.
David Bowie’s Space Oddity, Ashes to Ashes and Peter Schilling’s Major Tom.
Land Ho! by The Doors.
Hotel California by The Eagles.
Rime of the Ancient Mariner by Iron Maiden.
Led Zep’s Ramble On, Gallows Pole, Fool in the Rain, Going to California, Battle of Evermore.
99 Luft Balloons by Nena.
Don’t Stand So Close To Me by The Police.
The Boxer by Simon & Garfunkle.
The Pina Colada Song,cant remember the artist.
Bad Company’s Shooting Star
…and the ultimate Weird Al story songs, Trapped In The Drive-Thru and Albuquerque.
Also, Family Snapshot by Peter Gabriel.
More from the 70s:
Chevy Van - Sammy Johns
Ariel - Dean Friedman
Uneasy Rider -Charlie Daniels
I Do It for Your Love - Paul Simon
Convoy - C.W. McCall
I’ll add two of my favorites.
Paul Revere - Beastie Boys
The Mariner’s Revenge Song - The Decemberists.
Tons of songs from musicals. The point of many songs from musicals is to carry the plot along.
Yes, but I think a distinction can be made between songs that have a plot—where the song itself tells a story—and songs that have a backstory, where the song grows out of or comments on elements of the story. Many of the songs in musicals, as well as a few that have been mentioned in this thread, are of the latter kind.