I really like this series of games called the Witch Chronicles by Dark Tales Town. Starts with Witch Halloween, Witch 2 Hell Adventure, then a side story Jester's Theatre Museum, then Witch 3 Return, which has a couple cool DLCs too, and a couple more side stories Puppeteer: Control and Candle Demon. Sometime this year Witch 4 Hotel is being released. They're all on Steam, and are like, I guess, 2D side scroller puzzle games? With lots of animations and multiple ways to solve the game for different endings.
Same dev also made Code: Pandora, a sci-fi themed game of the same type.
Different kind of game, the Escape Dungeon series. You're a sorceress, archer, or in the most recent one, both... escaping from a dungeon. Its a top-down 2d adventure game I guess, you get power ups and abilities and that controls your tactics. And there are several different combat defeat animations for every level of monster in your way out, from skeletons to goblins to orcs to trolls, etc. etc. Each time you are defeated you start over and lose your abilites, but you are levelling up base stats as you play and never lose those. So the game is designed so that you will keep losing over and over until you eventually are powerful enough to escape, and there is a lot of being fucked by monsters going on.
Also check out Caroline's Fantasies. Its kind of a tech demo with a story. 3rd person engine not unlike any other rpg. Newer game from that dev is Affectionate Annie, haven't played it yet.