So, prefer not to have them, usually. I find they're often, like, the ONLY sound, so if it's silence forever and then suddenly squelching, kinda offputting. If there's voice acting and the sounds are in the same voice, THEN it's nice. But that's rarely the case.
I've heard ones that were basically 1 second audio loops that does not even remotely sound lewd; the worst one I've experienced sounded like hitting gravel with a boxing glove, it was horrible
When I started playing avn games with sound effects, I had it switched on, but soon discovered a good few that were really annoying. My default now is muted.