I remember that Dolly Parton did a show based on her song titles. I do not remember seeing any of it. But along those lines what songs or song titles at least could or should be made into movies or tv shows.
Examples
Carry On Wayward Son
Man of Miracles
If you’re asking for suggestions, which I think you were, story-based songs would obviously work best. Some that come to mind are:
Gypsies, Tramps and Thieves - Cher
Cats in the Cradle - Harry Chapin
Stan - Eminem
The Killing of Georgie - Rod Stewart
Papa Don’t Preach - Madonna
Smooth Criminal - Michael Jackson
Hotel California - The Eagles
I love the song Harper Valley PTA. 😁 That twinkle she has in her eye as she sings about that mama letting the hypocrites of the town have it is fantastic.
I don't know if I'm correct about this but I always thought this song must have been very hard to memorize. So many different scenarios that she's listing out at that PTA meeting. I'm probably wrong but it just always felt like this song had more words than the usual song. I was always really impressed that she sang it so flawlessly in that live performance.
The one that comes to mind right off the bat is Nowhere Man - first a Beatles song and then a TV show.
If you're never seen the TV show, I recommend it. It's a Prisoner rip off but it's quite good. The premise of the show is that a photographer takes a picture of something he shouldn't have and then has his life erased.