"Epilogue" from Les Miserable does it every time and I suspect I am not alone.
"Sunrise Sunset" from Fiddler on the Roof......never fails!
King Crimson is all about getting, holding then driving home a vice grip on the senses but never quite reach the point of tears with KC generally. Saw their last US performance on 9/11/2021 at The Anthem in DC (now available on CD) and it was quite an experience! Most gripping and often delving into beautiful but with a touch of irony usually. Take the tune "Epitaph". Beautiful musically but nothing beautiful about the subject material.