Sort of like say 'Dragon Age: Origins' with more payoff at the end of the romance subplots. Thus you will have sex scenes (including over the top ones) when appropriate to the game and it's progression.
I tend to think that the future of adult video game entertainment will be when you see regular games developed without concerns over censorship.
Not my genere of choice, but as I said I am slow to dismiss an entire genere out of hand. If it's simply a visual novel/adventure game, then it tends to not be especially good, in certain cases like the cult classic 'Knights Of Xentar' it can actually be fairly entertaining to the right audience. A lot of it revolves around how much gameplay there is along with all the sex. While most are garbage there are a few out there that are fairly decent, albiet a lot of them don't come to the US. I will go so far to say that while I have heard nothing really wonderful about the gameplay of THAT game in paticular, I am not so quick to insult all porn/hentai games. That should give you a pretty good impression of the game if your really curious. Here is a review of 'Rapelay' from Something Awful by someone who played it for the review.