Personally speaking as someone who hates horror and certain types of torture; no, there should not be trigger warnings. That's why game ratings were invented in the first place so those not wishing to see certain type of content are well informed in advance, if it's truly a concern.
For example I'm an absolute spineless wimp when it comes to eye or nail torture. Completely immune to all other kinds, but I can't fathom eyes or nails... it repulses me so badly that I get extremely uncomfortable with terrible shivers throughout the whole body. Whenever a scene like that comes along I usually just instantly look away while impatiently squirming in the chair just waiting for the scene to get it over with (like Theon's nail torture in Game Of Thrones or Sister Sage's lobotomy scene in The Boys). In BG3 the very first immediate cinematic is a parasite squiggling into the eye and later we have Volo using an icepick to give us a lobotomy, Ethel who violently rips our eye out, Orin who inserts one into Ravengard's eye or Orin again who performs a dual lobotomy in ACT III.
Yet despite hating that stuff out of pure disgust to the point of recoiling, it's part of the lore and I would never want it toned down or have a game pop out a warning asking me if I wish to see that content because the problem isn't the scene, the problem is me and I don't wish to be catered to based on my own weaknesses.If anything I want BG3 to increase the intensity of all its mature-rated content, rather than treat me like a child by downplaying them through obscurity or comedic tones, because when the developers have the courage to properly portray dark or controversial themes it becomes all the more better and richer for the overall experience. Not to mention that much more satisfying and appreciative when saving people from such fates, or eternally damning them to such fates. The stakes are drastically higher when something disturbingly resonates with the player.
Without content that is dark, graphic and outright disturbing to genuinely portray the heavy reality of its world and consequences that most of its denizens are living through the story becomes bland, loses its charm and its world doesn't carry any real weight. Personally I enjoy when a game is a graphic moral playground that has the poor truly suffering, the rich starved of morals, those in-between eternally damned and the children always in danger. Survival of the fittest, death of the weakest... with me behind the wheel to decide which way I'll go, no matter how disturbing it might be because I wish to see free and creative imagination, both good and bad.
For example:
- I love what happened to Hope because it truly puts into perspective what kind of place it is by setting the tone for the entire house and Raphael as THE devil. It's a place of eternal damnation spent in utter misery and it sends chills to even think about being imprisoned in such a place, cursed by any of the infinite fates others are suffering through in that house. Hope's form of torture wasn't even singular, as her being forced into sexual pleasure to both receive and provide was just one of countless forms of torture that Raphael continues to conduct on her in order to break her. Without her psychological traumas earned precisely by being used the way she was used, the whole significance and dread of the place comes down drastically.
It's the hardship and vile deeds that makes the setting that much more serious (and interesting) by seeing just how far an actual Devil's imagination can go and I love seeing world-building like that. Personally I found her flesh being melted while alive more disturbing than her being used for pleasure, because unlike pleasure the other one significantly scarred her to the point she never stopped hallucinating (as a defense mechanism against such unbearable pain).
- Same for Harleep, an incubus that takes over our body with no effort. It wonderfully portrays just how dark the deeds in that room are and how helpless anyone is once they enter it. I never see any praise about the absolute wonderful dread her encounter portrays by just how many souls Harleep condemned to eternally mindless sexual servitude, to be used as nothing but a warm body for sex sucked out of free will for all types of life in the hells to do with as they please.
It's so amazingly dark I wish they did more disturbing stuff like that.
Depending on the type of character I roleplay; if I am playing good I always go down for some sucky sucky with Harleep just to show her the power of sheer will. However if I'm playing evil she's an excellent conduit to eternally damn a companion to eternal sex slavery.
Like Astarion who was annoyingly pushy about having sex with my Dark Urge, so I played the long con by flirting with him as much as possible... only to then give him what he wants, just not in the way he expected; an eternity as a mindless sex slave in the hells (the others did not fare any better that run either) 
![[Linked Image from i.imgur.com]](https://i.imgur.com/j4iE0je.jpg)
- Ethel as well. One of my favorite portrayals of hags out there because it hits so close to home about folklore tales of "Baba Yaga", an old witch that kidnaps children and performs all sort of sick curses upon them. Mothers tell these folklore stories to children to protect them from strangers and to ensure they run home when it's dark, I personally was scarred throughout my entire childhood of the dark because of the stories about Baba Yaga. I had nightmares for over a decade about her.
But see it is precisely that dread and horrific fear that truly drives forward how serious things are. Ethel perverted a thief's body into a tree to guard her home for centuries. She has a woman trapped inside a mirror eternally. Another woman holds her decapitated head in her arms still alive. Mayrina's baby was gonna get eaten by her so she can turn its corpse into her own daughter, she was probably gonna feed Mayrina to the baby later too (kinda why she says Mayrina is "marinating").
- The goblins eating a roasted Dwarf at camp and having chopped up remains deeper in the camp. That was amazingly gritty, seeing humanoids degraded into just afternoon meals for goblins who treat it as humans treat chicken. They talk so much about eating people and so on, but then Larian forbade having tiefling children killed and barely displayed it for the grove raid. I wish they kept their courage about this. If we raid the Grove have the children roasting over the fire, have a few of the druids impaled on the gates as a sign of victorious conquest. It's already implied that they're all being eaten, so have the courage to show it.
- Minthara's sex scene, because it was so graphic, wonderfully portrayed a Drow fully in heat wanting pure carnal pleasure born out of genocide committed to please her goddess. Our character used to lift their leg over Minthara's shoulder so she can go downtown, then she used that leg to push us onto our backs to perform her famous 69. It was hot, it was pure carnal pleasure, it played into the evil theme, her character (and ours)... but with full release it got so terribly tamed it entirely lost its nuance by it being just some kissing, touching and the 69. So bland in comparison.
Show me true creative imagination, don't downplay it.