Resident Evil 4 has too many awesome deaths to list...so I'll say being hit (with low health) by a speeding car whilst crossing a high-speed freeway on GTA IV.