Once in a Lifetime by Caribdis was fantastic, and the new game he's working on, Eternum, is even better (though not yet finished). He is a very good dev too.
My favorite porn game of all time is Summertime Saga. It has so much content, so many choices, and a great story. It is more sandboxy than just a visual novel though, and the devs suck.