Wow there are a bunch (a lot that have been said) ...
The music in Gladiator when he's reminiscing about his family at the end of the movie when he see's them as he's dying.
The music playing in Braveheart after his wife is killed and they are burying her, when the father puts his hand on Mel Gibson's head.
The music playing in Braveheart at the end after he yells freedom and see's his dead wife in the crowd (I think there's music there haha).
The music in We Were Soldiers that plays throughout different parts of the movie (i think someone mentioned it - Hymn to the Fallen)
The music in The Patriot when his first son get shot outside his house.
The music in Terminator 2 as Arnold is lowering himself into the molten liquid.
The music in LOTR:TTT at the end of the movie when Gandolf comes down that hill with all of those horses as the sun is rising.
The music in the opening cut scene in Call of Duty 2 on XBox 360 (yes I know it's a game but it's a DVD so it's close enough to a movie

)
I'm sure there are plenty more I just cannot think of them right now.
EDIT:
Also the music in Crash played a HUGE part on the emotional affects of that film.