Lord of the Rings, the end of return of the king made me weep like a baby and as a kid, Dragonheart the death of Sean Connery, oops I mean the Dragon, was sad.
One Piece has made me cry more than anything, Tony Chopper's backstory as well as Nico Robin's and many. many other scenes