I think my feelings about this sums up with : Romance, sex, brothels, one-night-stands, epic love stories? yes, but if it makes sense or add something to the world and the story.
I remember the "night lady" of the gothic game included a short dialogue and cutscene and all that stuff but it made no sense for her to be there and she offered nothing more than a nude cutscene.
In other games like tyranny, DoS2 or PoE 2 you can chat with the ladies and gentleman in the brothel, learn their stories and some of them are part of a quest, something that adds flavour to the city itself. I hope BG3 goes in that direction.
