Barry Manilow - Copacabana
Kinks - Come Dancing
My favorite story song is Iron Man.
duh dun duh dun dun da da da da da da duh dun dun
“Take the Money and Run” - Steve Miller Band
You brought the Kinks into this, without mentioning Lola?
Bob Dylan, Hurricane
Maybe he thought one song about Lola was enough? 
I thought of Copacabana too, but I was afraid to mention it.
“Lola” was on RealityChuck’s list earlier,
a list to which many more Kinks songs could be added. But they may or may not be what the OP is looking for. Mostly, Ray’s songs don’t give us linear narratives (first this happened, then this happened…); rather, he’s terrific at creating characters and telling about those characters and the situations they’re in. (And Ray did call his one-man show and the CD that came from it “The Storyteller.”)
Ah, shoot, my bad. :smack:
Bang Bang- done by many, done best by Nancy Sinatra. What on the surface appear to be really simple lyrics are actually pretty deep and vivid.
Well, if we’re going to mention The Gambler, then how about Coward of the County?
Whiskey In A Jar - Thin Lizzy
Scenes From An Italian Restaurant - Billy Joel
Stan Rogers has a bunch of good folkie ones (too many to list probably)
Barrett’s Privateers
The Maid on the Shore
Athens Queen
White Squall
…
and Woodbridge Dog Disaster for laughs
Lost Keys (Blame Hofmann) & Rosetta Stoned by Tool
On the same note ( 
), Tenacious D’s “Tribute”
Devil Went Down to Georgia - Charlie Daniels Band
Coward of the County - Kenny Rogers
The Downeaster ‘Alexa’ Billy Joel
Bad Wisdom Suzanne Vega
No More I Love You’s Annie Lennox
How Beautiful You Are The Cure
What about Iron Maiden’s Sameul Taylor Coleridge tribute, The Rime of the Ancient Mariner? Does it count?
Examples of bad story songs:
Run Joey Run
Blind Man in the Bleachers
“Albuquerque” and “The Biggest Ball of Twine in Minnesota” by “Weird Al” Yankovic.
Mark Knopfler, A Prairie Wedding – he captures the narrator’s emotions beautifully.
Guess Who I Saw Today, Nancy Wilson
Hello Big Man, Carly Simon (re: parents/refers to father’s co. Simon&Schuster)
I think every song Gordon Lightfoot ever wrote tells a story. The Canadian Railroad Triogy, Sundown, If You Could Read my Mind, Rainyday People
Cold Blue Steel, Blue, Cactus Tree, Peoples’ Parties by Joni Mitchell
At Seventeen by Janis Ian
Night Moves, Turn the Page by Bob Seger
Cinderella by Firefall
Legend in Your Own Time, You’re so Vain by Carly Simon
Hotel California, Take it Easy by The Eagles.
Horse with No Name, Desperado by America
Rock Show, Magneto & Titanium Man by Wings
Maggie Mae by Rod Stewart