Well going back to LOTR, one of the most memorable (it's not exactly awsome) deaths for me has to be the death of Theoden. He was basically killed by his horse. What a cruel twist of fate! It was also for me one of the most saddening deaths in the book.
But yes there is a ton of good deaths (if any death is really a good one). I do have to give credit to the Balrog though. He did give Gandalf quite a fight before he went down
And Smaug's death has to be one of the most spectacular