[Puke]

Some good deaths in The Seven Samurai, specifically the duelist, and also Toshiro Mifune's character.

as far as horrible deaths that made for great movie pathos, see Galipoli.

and for heroic ways to go, how about Michael Garibaldi in the alternate-future where he dies defending the station against invaders?

and how about that guy in point break that dies surfing in the storm.