Elianna, you sadist.
I'm not sure about
great deaths, but I felt the most stirring demise was the departure of Boromir. His passing & his final speech with Aragorn were touching, & made all the more poignant by the dirge sung by Aragorn & Legolas for the fallen Captain of Gondor. Perhaps it was particularly moving because some of his last thoughts were of failure, & the words 'I am sorry. I have paid,' indicate that he felt it was to some extent justice served that he had been slain defending his hobbit companions only a while after he himself had attempted to assail Frodo. His final plea to Aragorn, to 'go to Minas Tirith and save my people!' was, in my mind at least, an important factor in Aragorn's decision making from that point forth, as it gave him a tangible oath ('Be at peace! Minas Tirith shall not fall.') to fulfil rather than simply a doubtful destiny to look forward to.