Sex is a major part of life: and that's how I like my RPGs to be, a lifelike adventure that I can relate to, in all ways.
DA:O had a good amount of sexual material IMO.
The thing about nudity and sexuality is, that it is rarely (if ever?) implimented in an interesting way. If violence in games were all about watching cutscenes of digital creatures ripping each other heads off, that would be gratuitous and boring. But that's where most systemic focus is on... DnD origin is a wargame afterall, not datesim.
If one wants to make a detailed game about relationships and sex, then sure... I don't know if it would be my thing, but why not.
As it is however, romances in RPG feel to me gratuitous and at best unnecessary.
Where something like violent Warden's initiation in DA:O held narrative and character importance, DA sex-scenes in underwear (because after ME we don't even have balls for that), backed by shallow romance mechanics were quite laughtable. Witcher2 already doesn't hold up well in that regard, and I imagine, watching polygons rubbing in Witcher3 will be just as awkward in couple years time. Though, at least in Witcher3, sex scenes are at least part of a coherent romance arc, giving them more right to be.
With violence lack of connection helps - afterall slaughtering on mass is not a such fun and nice thing to do (or so I am told). It's a bit like I had a really tough time sitting through "No Country for Old Men", while John Wicks or Warhammer games dont affect me (though I did find JW3 to be too much). Lack of connection in romance/sex scene, on the other hand, works against it.