"He'll Make Me Happy" from Muppets Take Manhattan. Happy Tears, but tears none-the-less
That one and
"True Blue Miracle" from Christmas Eve on Sesame Street, most of all when Gordon sings the last line after finding Big Bird.
"You're Gonna Be a Star", the whole song, but most of all, the musical version when Sahu is climbing the stairs to be a star in the sky in Don't Eat the Pictures
And 'Bring Back The Wonder We Knew Long Ago' from Fraggle Rock always makes me cry, as does "How Wide, How Far, How Long" from The Gorg Who Would Be King