My favorite band RUSH has LOTS of songs that are stories. Most of them are I guess.
Of course my name-sake 2112 which tells the story of a guy finding a guitar and wanting to play it, but he is refused by the elders.
Manhattan Project about the development of the atom bomb in WWII is good, and with no judgement:
https://www.youtube.com/watch?v=HTkicdO_64w
Imagine a man
Where it all began
A scientist pacing the floor
In each nation, always eager to explore
To build the best big stick
To turn the winning trick
But this was something more
A dark story by The Doors, “The End”
https://www.youtube.com/watch?v=qLCmMABqCPA
The killer awoke before dawn
he put his boots on...
John Prine, Yes I Guess They Oughta Name a Drink After You
Oh, I get drunk most every night
Seems like all we do is fight
The more I drink
The less I feel blue
Sometimes I feel like an awful fool
Spendin’ my life on an old bar stool
And yes, I guess they oughta name a drink after you
John Prine (again), Far From Me
Well, I started the engine
And I gave it some gas
Cathy was closing her purse
Well, we hadn’t gone far in my beat up old car
And I was prepared for the worst
“Will you still see me tomorrow?”
“No, I got too much to do”
Well, a question ain’t really a question
If you know the answer too