Here are my most memorable ones...
Tarka the Otter - Cannot to this day sit through that film, I did it once and cried so much I thought I would dehydrate, now I flat out refuse to watch it.
Pay it Forward - The candlelight vigil, I do great until I get to that part.
The Sixth Sense - When he tells his mom in the car he talked to her mother, oh boy.
Beaches - Pretty much the entire latter half of the movie.
The Green Mile - When Percy stamps on Mr Jingles among other scenes.
Notre-Dame de Paris - Ok, it's a musical but wow, when Quasimodo sings Dieu que le monde est injuste and Danse Mon Esmeralda, I'm balling for sure (pretty embarassing in a theatre too), thank heavens I now have the DVD and can sob unrestrained.
Ghost - who didn't cry?
Philedelphia - At the end, that one got me in the cinema too, now I avoid going to see movies that I think will make me cry, I wait for the video to come out.
I'm sure there are many more, but those are the ones that come to mind right now