Violence for it's own sake is not appealing at all. What's appealing to me in games is the narrative, and the overcoming of evil. Violence is just a means to get there, not the end itself.
What I find curious is that people often confuse violence with gore. And age ratings go the same way. Like it's the gore that is the problem and not the violence itself.
I think killing is killing, whether the game shows blood and gore or not. Actually I Think the downplaying and removal of gore is more dangerous, as it trivializes the consequences of violence. A gory game might shock a kid, which is good, violence should be shocking. On the other hand games that removes gore and makes your kills evaporate are normalizing violence.
Killing should be depicted in games with the full gory consequences, or not at all.