I sang in a choir for almost 5 years when I was still in school (8th grade to 12th), won a few state competitions, studied music theory/history/composition. Probably know the lyrics to over a million songs by heart.
I'd have to say lyrically Dolly Parton's Jolene is absolutely perfect, the urgency in her voice is reflected in her guitar work. It's simple, brilliant and really tells the story of a woman who doesn't want to lose her normalcy.
Harper Valley PTA is another really great song by Jeannie C Riley.
The entire album Wizard of the Hood is a perfect specimen of re-telling a story old as time (Wizard of Oz but in the style of Juggalos, it's a thing, google it).
Sweet Baby James by James Taylor
I mean I could literally go on for days...