The Grunts appears in most locations with scary atmosphere but not the Brutes

[Mudbill]

It's probably mostly subjective whether those scenes are going to be scary or not. Some consider the entire game to be scary. If I were to put it up on a scale, then yeah the storage and prison come at the top, but the Choir is probably not far behind.