I guess the consens is, that warnings really aren't warranted.
Since Crimson brought up The Boys : I guess it would have been easier to just write before every episode, what's not in there, instead listing off everything, that will be shown. By now, the show is well known for not making compromised and there like with BG3 I'm totally ok with it.
I think a good story at one point should make you uncomfortable and maybe make you stop and think along the way. I certainly thought more about the fates of poor hope or the citizens of Reithwin than any of the romances, because it was shocking and sad and it brought up the wish to help.
Crimson: I agree with your depiction about Hope and Haarlep, it is not there without sense, it drives home the fact, that you are in a very dark place. I think many people see Raphael as pretty nice compared to Mizora for example, until they reach the HoH and go through everything, they find there ( the journals about Hopes stay there are heartbreaking too). It's not mindless, it's there to make a story and a characterization ( in this case Raphael, since everything there is happening on his whims) complete. I often voice, that I don't like Haarlep,but I guess, that is exactly, what we are supposed to be feeling about him. Even if we do the deed with him, it comes back to haunt us.