No one has yet mentioned the part that always makes me cry: in Cirith Ungol, when Gollum is like a hobbit again for a few frail moments and as Sam awakes it's gone forever.
And many times I've cried when the rohirrim enter the battle of Pelennor fields. (Well that's not due to grief...

)