My all time favorite was, Tuck Everlasting.
I read it to my daughters last year as their bedtime story and still cried like crazy. My kids just looked at me weird...but my older daughter understood. She cried with me.
Don't watch the movie. Read the book first if you plan to watch the movie. The movie does not show the real meaning of the story...well, it does but not in its purest form.