I always felt like DCOTE was two games lopped into one. Straight up weaponless horror, and then there was the armed section, which I wasn't so sure what to think of. I felt powerful, the enemies around me were fish-people who clearly didn't know how to handle a gun quite right. But the thing about guns was that you didn't need to know how to handle them properly to land a shot, and kill Jack, as quite easily evidenced in the street chase.
And then in the latest stages, the game took your guns away. THAT, was terrifying... But i was able to beat it. To me, it was just the right level of scary, and I wish I could go back and replay it properly.