I can think of several deaths across the franchise that are absolutely brutal. A few that come to mind are:
Glasp death Resident Evil: Revelations 2, Majini death Public Assembly (if you lose during the Executioner stage you get a special cutscene after), Chainsaw deaths (especially in 4 and 4 Remake), Garrador deaths via impalement (RE4), being killed by an Afflicted in Revelations 2 (Claire dies with her eyes open), Moira shot multiple times in Revelations 2, Duvalia torso kills in Resident Evil 5, being swallowed alive by Hunter Gammas in Resident Evil 3: Nemesis and Resident Evil 3 Remake or Lurkers in Resident Evil 0, kills by Rasklapanje in Resident Evil 6, and a huge one also from Resident Evil 6: being sliced to pieces by a meat grinder.
I'm split between Resident Evil 4 and Resident Evil: Revelations 2 as having the most violent deaths, but I think I have to consider for myself that meat grinder death as one of the most savage and violent deaths that I've ever seen in a video game.