Some of my best gaming moments are associated with violence, say Soldier of Fortune, Mortal Kombat 1-2.
Still, dunno if it's old age, or there is a fine line somewhere out there between tasteful gore and forced splatterfest, because when I saw the fatalities from the latest Mortal Kombat on jewtube,
it felt like the guy who designed them was trying too hard.
Carmageddon is a curious case for me, I didn't care about the run over pedestrian thing. I was genuinely more interested in wrecking the other cars , or making a nice head-on collision. It got you a larger time bonus, more money,
and you could sometimes capture the car and use it in the future.
Also, the damage model was pretty decent for the time.
On the other hand, I totally cannot into stuff like Postal, Prototype and the likes (although number 1 had its moments).
I think it's mostly about beating a tough opponent then being able fuck him up real good. Sorta like Mortal Kombat fatality is like saying "good game, mate"
With defenseless victims, it's just not the same, but applying well rendered brutality to someone or something that sorta deserves is pretty satisfying .
A nice example of tasteful violence is One Must Fall 2097. Not only it's a neat fighting game with robots, stats, character development and a freeform combo system, it also has fatalities which look pretty damn satisfying at times
(and also open up various secrets in the game!) . Totally bloodless and PEGI-13, but there's something satisfying in impaling the end boss on the elbow spikes of your Thorn.