Yea, Springsteen's Sandy is a good one. How about the Stone's "Wild Horses" from Sticky Fingers. It would seem in your situation nearly the perfect dicotomy: good music being created by the Rolling Stones (whom I recall parents thinking were among the root of all evil impacting the young - remember Kristofferson even wrote a song about it, "Blame It On The Stones"?).
The Most Beautiful Song of The RnR era?
I'm about to spend a week with my father in law, who loves music but insists that nothing of interest (that is, beautiful) has been produced since WWII. In order to get a little music in, I thought I'd burn a compilation cd that might not offend his sensibilities too deeply. "God Only Knows", "Hello, It's Me", "Truly, Madly, Deeply", "Something", and "Bee's Wing" are in. Many others are under conssideration. Your additional suggestions would be appreciated.