I'll consider using one of these types of mods when/if they come out. So far the only thing that was bad for me was in the introduction, and it let me look away (which was actually quite immersive).
I'm quite squeamish but if it isn't constant I'm not so bad. I totally relate to the people for which it takes away some enjoyment of the game though. It does add to the atmosphere sometimes though, so I might just leave it on if it doesn't get too bad later in the game.
Spoiler It was quite satisfying they let me kill the torturer guy in the introduction after his friends walked away. My character isn't typically a murderer, but that guy was horrible.