Most emotionally intense would be About Schmidt. I could really relate to the main character, really got to me.
The Good, The Bad And The Ugly had one of the most intense suspense moments for me. Of course it was the graveyard scene, I was literally sitting on the edge of my seat, holding my breath.