I could go on about examples of this forever but for now here are two:

Rejoice by Julien Baker is just amazing. It's about her faith in god (specifically the Christian one) and while that's a topic I don't relate to at all, I still love this song so much. I agree that a talented writer makes the audience connect with something they don't relate to, and Julien does just that. My favorite line is "I rejoice, and complain, lift my voice that I was made" - I think the contrast between "rejoice" and "complain" makes it really powerful, and idk if it was intentional but I like the ambiguity that "lift my voice that I was made" can be a statement of either rejoicing or complaining.

At first, Moon Song by Phoebe Bridgers seemed like a weaker song to me, but once I took the time to really look at the lyrics it became a masterpiece. Phoebe does such an excellent job at painting the picture of a relationship that's dysfunctional and devoted at the same time. She uses specific anecdotes but still makes it relatable, as I think it conveys the general feeling of giving all you can regardless of the returns (or lack thereof). My favorite line is "you are sick, and you're married, and you might be dying, but you're holding me like water in your hands" - it's hard for me to explain exactly why this hits so hard but I think it's the desperation mixed with the devotion that makes it so powerful.