Song lyrics that tear your heart out, stomp on it, and leave it weeping in the dust.

Absolutely. In that case, add “Sit On My Face” and “Medical Love Song” to my list.

Back to the OP, though:

The Eagles’ Desperado (the whole album) always makes me a little tight in the throat, since the whole thing is about getting older and looking back at the past, but the song that gets me most is “Saturday Night”:

Seems like a dream now,
It was so long ago.
The moon burned so bright
And the time went so slow
And I swore that I loved her
And gave her a ring
The bluebird was high on the wing.

Whatever happened
To Saturday night?
Finding a sweetheart
And holding her tight
She said, “Tell me, oh tell me,
Was I all right?”
Whatever happened
To Saturday night?

The years robbed the railroad
That ran by my door.
Now there’s boards on the windows
And dust on the floor.
And she passes the time
At another man’s side
And I pass the time with my pride.

What a tangled web we weave
Go 'round with circumstance.
Someone show me how to tell
The dancer from the dance.

Whatever happened
To Saturday night?
Choosing a friend
And losing a fight.
She said, “Tell me, oh tell me
Are you all right?”
Whatever happened
To Saturday night?

Whatever happened to Saturday night?
Sniff.