Two schmaltz nominations: "It Had to Be You" by Harry Connick Jr from When Harry Met Sally, and "The Sound of Music" by Julie Andrews from the movie. A sentimental favorite: "The Look of Love" by Dusty Springfield from Casino Royale.
Most compelling vocal you discovered in a movie?
I love music and find myself drawn to all sorts, most kinds of jazz, opera (except Wagner, which I have seen performed), rock, pop, world, etc. The radio, TV, concerts are obvious places to discover new tunes. How about the movies? Is there a song so wrenchingly beautiful that you discovered while watching a movie that you sat around to see the credits and then rushed off to buy it? For me the most recent tune was "When I Dream" by Carol Kidd in the highly recommended South-North Korea espionage drama "Shiri." The song is wonderful and fits the movie just so. If you haven't seen this, I urge you to find it somewhere. It was the highest grossing film in Korean history and while it is explosive, the character development and underpinnings of the motivations provide some nice food for thought.