It feels unnecessary to me and seems like resources that could go into the game itself in a meaningful way are being wasted on fluff. The impact of a sex or love making scene could be great, but it depends on how it is presented and the frequency. From the little I've seen of the Witcher series it doesn't exactly handle this well though. It could be done great this time for all I know, have emotional resonance and be meaningful character and story development, but almost every example of this I've seen from gaming, to most movies, sex is treated in a very pandering and porny way so I don't have confidence they can deliver anything above that.