Other notable examples:

This games: http://granony.r.ribbon.to/game/index.html

Torture Game 3

Yandere Simulator

Manhunt 1-2/The Punisher - lots of gore with the male enemies

GTA, especially V with the dismemberment mod

Max Payne 3 with the female enemies mod - I don't know where to find it now though, there was a thread on Undertow website.

House of Velez 1-2/VHS slasher games from Puppet Combo

Happy Wheels/Guts and Glory - cheesy arcade racing games in which your character may be dismembered by countless user-made traps and obstacles

Garry's Mod/Source Filmmaker - You can see great EVMC's and Pestilence's works in /3dcg/ or play Garry's Mod - this is the universal sandbox to create eveything. There was a dismembering mod, which allows you to dismemeber any model with the fountain of blood and a ragdoll torture map. SFM is the very user-friendly and advanced tool to create the movie you want, but very dependning on your free time, PC specs and disk space.

Monolith's Blood - the name speaks for itself. Atmospheric and satanic gory shooter. Fresh Supply on Steam is the fastest method to run it on modern rigs. Painkiller: Black Edition is fine too.

Grezzo Duo - a shizophrenic and gory Doom 2 mod. You should see the gameplay on YouTube - it's worth it. The sequel is almost done.
Also, Brutal Doom

Darkest Dungeon with some erotic mods - if you want to play as the team of constantly hurt and suffering girls. New X-COMS are kinda similar in this way

Party Hard 1-2 - it's not a good game, but maybe you'll like it