[SPOILER]
The end of the missions "A Flame in the Dark" and "Homecoming" both have visuals implying torture related to a character's imprisonment and execution
SPOILER:
Haunting case: Prudence in All Things also has a suicide toward the end of the questline. Audio is played of the suicide happening but the act isn't shown, although a ghost with a bleeding throat appears later in the same questline
[SPOILER]
While not strictly blood, the ooze in the main story mission "The Inkwell" is red and viscous and how it's presented may trigger similar responses to blood or gore, so it seemed worth mentioning here
Several of the haunting cases, especially in the early stages, will resemble stalking until more details are revealed
[SPOILER]
Haunting Case: "The Parting Shot" depending on who's alive when you arrive