“Cats in the Cradle” by Harry Chapin
I'll second "Butterfly Kisses" and add Harry Chapin's "Taxi".
Of course, Judas Priest has some songs that bring a tear to my eye, but for a different reason. :)