My position is a bit self-contradictory, I think.
In a realistic movie or story, I don't look at these scenes as enjoyable for it's violent content. The same is in a semi-realistic setting, like a good thriller movie. For example,
Babs Milligan strangled im "Frenzy" was just sad. The same goes for female soldiers shot in a WW2 movie.
A similar scene in a light hearted action or horror movie would be enjoyable. Especially if the victims are a villain's henchwomen (aka Zako).
But here comes the twist: I love to know their
personal background, and since it's almost never hinted, I create it in my fantasy. They get a funny, painful, humiliating, often over the top brutal, comeuppance, and they certainly deserve it. But they are also somebody's daughter, sister, girlfriend, mother...
So a story can turn really sad and the question "whether to silence the sentry temporarily or permanently" may become important.