I just finished playing through it, it's lighthearted and comedic! There is one option with disturbing imagery but you get a heads up and are able to avoid it if you don't mind missing that achievement, although the moment is still very much played for laughs and doesn't impact the overall tone of the game