One game would be
The Last Sovereign. It's an RPGM game but it's honestly on the scale of a Final Fantasy game in terms of scope both story and length-wise. The world has a chosen hero narrative that gets flipped on it's head while you use newfound power to work both in secret and in the open to conquer it for the betterment of society. You normally control your standard RPG party but in certain phases, you have to control armies to win wars and your previous decisions throughout the game come into play, e.g. did you fund that road or did you support that magical guild. Sex scenes are written vs. pictures but it's the most in depth porn game I've ever played. The sex scenes are incredibly well written and fit the narrative beautifully. Interesting and unique characters, deep story, geopolitical intrigue, I can't recommend it enough.
Hopefully you'll give it a try even if it's not exactly what you're looking for.