Your thread title suggested something other than your question (A game or a film).
I was going to invoke the old video game Dragon's Lair as an example of something that feels like both.
A game that played a bit like Dragons Lair that could actually be kinda cool. Real-time sexy fun time. Not sure what the consequences would be if you missed a keystroke combination though...
If you 'stayed' with the fantasy theme playing a female MC, I suppose that you could do something like use your sword to cut the belt of some handsome adversary, so his pants drop around his knees, and move in to give him a BJ before he can react, and then have to judge when to change things up before he gets annoyed and decides to attack you instead.
And of course, pleasing a Dragon sufficiently to keep him from eating you could be an interesting finale...
It'd be kind of a weird game, but it could be interesting.
Back to the question you actually asked, yeah I like a balance of character building, story development, and of course sexy fun time. It's a fine balance, but when done well it could work quite nicely. Unfortunately, I can't think of any 'perfect examples', as I haven't found that perfect balance of this (for me) as of yet.
I still remember spending umpteen hours grinding solar panels in that one game... (Spaced Out). Or repeating the same sex scenes over and over in other games, because there wasn't a lot of variety on that front when trying to build up stats, etc... But since I downloaded these games for free, yeah I applaud the effort at least, and have learned to not expect the moon and the stars.