The bit that always gets me in Titanic is when that sailor is shouting for survivors in the lifeboat. You can hear his desperation and horror in his shouts, was a fantastic piece of acting in my opinion
Also, Deep Impact, when the blind guy is talking to his son, and United 93 at the end, possibly one of the most powerful scenes I've ever seen