I never cried in the books or the films, but when I first read the books I got very upset when I thought Frodo was dead when the spider had him wrapped up for dinner. It was close enough to the end to be just possible.
Of course we know he wasn't dead after all.
Kahnshefal