I used to get weepy at the end of Return Of The Jedi when Luke sees his father, Obi Wan and Yoda in the Force Light. Then that a-hole Lucas had to edit Hayden into the mix and ruined it forever.
I also get misty eye during Toy Story 2 when Jessie is reliving her days with her former owner. The part when she thinks shes going to be loved again but ends up in a toy donation box is rather saddening.