Stupid actually, the opening scene of The Lord of the Rings (the battle of the Last Alliance) made me cry/tear/wet my eyes, while the scene where Gandalf (or Boromir) died didn't. I guess that's just because I already knew the book. The opening scene was just so... cool. :)