Board Thread:The Last Sovereign Discussion/@comment-2404:4408:23F1:2F00:3136:6552:F2A5:60BB-20191020083241/@comment-35006067-20191028182058

Did you try some classics like the Dragon Age series or Neverwinter Nights 2?

No game I can think of is going to fit perfectly all of your criteria at once but if I had to namedrop a few contenders in different genres I would say:

Undertale. An obligatory mention in the category "character-driven" and "subverting trope". It is a good game, but short, and not as revolutionary as the hype says (though objectively the hype was so high nothing could have lived up to it). The characters are very memorable however, one cannot deny that.

Long Live The Queen. Low fantasy political chess with a huge density of impactful choices, albeit more medium-length and with a cast full of jerks.

The Metal Gear Solid series. May click or not click with you but it does try a lot of things with its plot, characters and gameplay/story integration.