tinyE: Am I the only one who cried at the end of "Never Ending Story" when he chased away the bullies and flew off into the horizon?
You hadn't read the book yet, had you?
Basically, the entire movie consists of the producer and director showing the middle finger to the author of the original story, and the ending is one of many, many scenes in that film that perfectly symbolize that attitude. They explicitly said in interviews that they had to take Michael Ende's crerative, original story and "simplify" it, as well as "giving it an American wrapping", because they believed that any attempt to capture the original story's spirit would be too much for American audiences. So they didn't even try. They took one of the most original and thoughtful children's story of that decade and turned it into the usual vapid mush.
Regarding the original question: I rarely cry, but I regularly get wet eyes - usually only with happy scenes though, never with sad ones. Just happened last week when we were watching "Frozen". Which is, coincidentally, a good example of a movie that takes massive liberties and still succeeds. Because there, the goal was not "simplify everything to make palpable for a mass audience", but "tell a mature story that people can relate to", as in the relation between the two sisters.