Here are some that came to mind for me, some might be closer to what you are expecting than others, but I feel like they fit the description decently.

Father John Misty - Mr.Tillman

• The entire song is from the point of view of a hotel front desk clerk asking a guest about his odd behavior during a previous stay.

James and the Shame - Believe Me

• Rhett McLaughlin of Good Mythical Morning fame's solo project where he details his struggle with his changing religious beliefs after a lifetime in the church and how he feels others see him now.

Bo Burnham - FaceTime with My Mom (Tonight)

• Part of Bo Burnham's comedic yet serious special, Inside, he filmed and produced all by himself during the Covid lockdowns.

Head East - Never Been Any Reason

• The singer asking trying to make up with his partner about being on the road for long durations and she feels like there is no reason to think about here when he is on tour.

Sheryl Crow - All I Wanna Do

A story telling describing drinking at a bar at noon during a workweek when the man sitting next to her starts a conversation.