Romances should be like in the Pathfinder games, something you had to build up on throughout the course of the whole game.
D:OS2's issue is that it just suddenly showed up out of nowhere before the final act with zero warning, so it just ended up being comical. BG3's issue is the opposite, in that the intimacy happens way too soon. The latter would be improved by making it clear that it's likely to be a one time fling unless the player makes a serious commitment to following up on it as you proceed into the later parts of the game.