The Muster of Rohirrim. It was so inspiring, basically anything related to Rohan was awesome.
So far I have only read The Hobbit and read/seen The Fellowship of the Ring.
Here's how great these books are: I love to read, but I don't get emotionally involved in/affected by the books I read. However, FOTR has two places that really got me.
The Mines of Moria chapter was possibly the scariest thing I've ever read. It was so eerily tense and suspenseful that I couldn't help putting myself into the situation with the characters. I kept thinking, "We're going to die. We're going to die!" before I remembered that 1.) This is a book. I'm not invovled in this! and 2.) There's far to much story left for them to die now.
The other was in the very last chapter. The whole chapter was so emotionally charged, and the last bit with Sam chasing after Frodo was, for me, the most heartwarming part of the whole book. It's not exactly happy, but you have to grin when Sam nearly drowns himself jumping after the boat like a dumbass. It made me love him more than ever.
That part with Faramir tears my heart asunder every time