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.