While there are many games out there for folks of all ages, some are specifically meant for the adult demographic. You'll notice which games these are by the rating and warning on them about the type of content available.
Here's 8 of those games that are games have NSFW scenes in them.
God of War 3
God of War 3 revolves around Greek Mythology and ancient Greek society. So, it makes total sense that at some point you're going to encounter the Goddess of Love, Aphrodite. Of course, your encounter couldn't be complete unless she was doing what she's the goddess of, right? God of War 3 shows the beauty of the goddess in explicit detail along with her... umm... friends.