Are there any songs that always being tears to your eyes when you hear them? Not sad tears but well wistful or melancholy tears?

Quite a few but not all of them are songs.

Who Knows Where The Time Goes - but it has to be the original, sung by its composer, Sandy Denny, with Fairport Convention. I've not heard a good cover version, though there may be some.

Vocalise - by Rachmaninov. A piece for soprano or high tenor with solo accompaniment, it does not have discrete words, just long, single vowel sounds, usually "Aaaaaa". It has been arranged also for various solo, duet or trio instrumental-only versions. The title with a small 'v' is the term for the style.

Four Last Songs - Richard Strauss. I don't hear them often, so tend to confuse them with...

.... the Lieberstod - Richard Wagner, from his opera Tristan und Isolde. It is Isolde who sings it, I think as she is dying, as the aria (meaning Love [in] Death), but I don't know the story beyond that aria confirming the couple's love in life and death.   

Also from Wagner - the finale aria (Brunnhilde's) of Gotterdammerung, and the music that continues from her last words, through fire and flood, to an extraordinarily poignant passage as she is redeemed and peace finally settles over the world. Hers are not quite the last words of the operatic tetralogy though, when performed in full. As the tragic Valkyrie ends the song and flings herself onto Siegfried's funeral pyre, in a very brief moment one of the villains utters a final despairing yell of "Don't touch the ring!" all suddenly see is still on Siegfried's finger. Too late though, as the pyre blazing up then the River Rhine flooding, sweep away all the corruption the story has described. I heard this song only yesterday in concert performance, preceded as if in symphonic movements, by two other powerful, all-instrumental extracts:  Siegfried's Dawn Ride, then his funeral march, and that line was omitted. (Wagner adapted the ride music from his pastorale, Siegfried's Idyll, a birthday present to his wife and referring to a real Siegfried, their son.)

Lark Ascending - Ralph Vaughan Williams. (His name is often pronounced "Rafe", but I don't know if that's what he went by.) Principally for solo violin, after the orchestral central section, the violin is alone again as the lark has the last word, fading away skywards.

Curiously too, sometimes traditional folk, especially English dance, music - curiously because this is joyful, not melancholic; but the lachrymose quality for me is by the music's associations, not the music itself. 


++++

Of your list, I can find Amazing Grace a charming if slightly syrupy hymn but only if at a dignified, not rushed or dragging, tempo.  I've heard recordings of it being sung at funerals, but so slowly that though the mourning is no doubt sincere, the singing takes the hymn beyond dirge and into parody.

Similarly, You'll Never Walk Alone sometimes suffers from being turned into an excessive dirge, but I've heard recordings of it by the "massed choir" of Liverpool Football Club fans using it as their anthem at their home ground, and though I am not a sports fan, it is as stirring and moving a sound as a Welsh rugby crowd's Hen Wlad Fy Nhadau (Land of My Fathers), or very differently in mood and context, a Scots pipe lament.

Send In The Clowns does not  move me particularly, but I can appreciate it if sung well. The last version I heard was dire! Of songs from the musicals the one that does touch me is Midnight, from Cats. 



X