The closest any CV game came would probably be LoS. No tears, but I did have a huge WTF moment when Gabe murdered Claudia, and it really wasn't a dream.
It was genuine "wtf?! no way!!" and feeling bad for the character.
As much as I hated Mutie, that scene did genuinely shock me.
Poor Gabriel's gonna need a lot of therapy. Except instead of biting pillows, he'll be biting... well, you know.