Romancing NPCs is all base game.
The NSFW will be a mod that'll come after full release. Reason being is it has to stay SFW in the base game to be permitted in certain regions.
But it'll just alter the images you see during romance scenes, the memories page and certain dialogue.