Most of BioWare's romances were more like a mini-game with a sex scene as the prize at the end. I think DAI got much better in that regard, though it had other issues.

But this is hard to do and so my expectations are not high. I would love to be pleasantly surprised.

As far as sex scenes, the fade to black works fine for me.