Well, the first ten minutes of Trek 09 were very emotional. I didn't shed a tear, but the sheer brutality of the attack and the echoey near-silence of Kirk's birth combined with Giacchino's score was very moving. I also got a little choked up during the shuttle sequence when the new Enterprise was revealed. It was treated with such adoration and respect that it felt a little like coming home again.
Speaking of Giacchino, he can really bring the tears when the situation requires. The first eight minutes of Up are virtually unwatchable for me. I get emotional even thinking of them and the music was a big part of that. Given the right material to work with, he might be enough to push me over the edge. We'll see.
Of course, I also cried at the end of 'Armageddon,' so what the hell do I know?