Music does that. I always say, music can break your heart, and it can make you love having your heart broken. In fact that phrase auto-completed for me.
There are two songs I can think of right now that make me cry. One is "The Dutchman" because I am soon to be 74 and I can imagine myself getting to that point and my wife, who will probably outlive me, taking that kind of care of me.
Then there is Bette Midler's "The Rose" because, well, just because. I can’t even read the lyrics without becoming all unglued.*
Then there is classical music, in particular late romantics such as Tchaikovsky, Mahler, and Bruckner. I've loved classical music since my teens, but it has taken on new resonance, for whatever reason. But it has to be live to really bring on the waterworks. I was at a live performance of Tchaikovsky’s Symphony#6, the "Pathétique," by the Boston Philharmonic and I cried like a baby through the whole thing. The thing about it is, I'm surrounded by other people, so you would think I'd be embarrassed, but such music can make me relive every love affair, every heartbreak, every triumph, every significant event in my life and none of that is about to happen again man all that is left to me is the big D, so who gives a flying fuck? Let them see me cry.

*The Rose
Bette Midler

Some say love, it is a river
That drowns the tender reed
Some say love, it is a razor
That leaves your soul to bleed
Some say love, it is a hunger
An endless aching need
I say love, it is a flower
And you, its only seed

It's the heart, afraid of breaking
That never learns to dance
It's the dream, afraid of waking
That never takes the chance
It's the one who won't be taken
Who cannot seem to give
And the soul, afraid of dying
That never learns to live

When the night has been too lonely
And the road has been too long
And you think that love is only
For the lucky and the strong
Just remember in the winter
Far beneath the bitter snows
Lies the seed that with the sun's love
In the spring becomes the rose.