Weapons or no weapons in horror games?

[Kreekakon]

I am a difficult customer to please in this department. If you give me a gun that even HALF works, I will try my damn hardest to hoard ammo and make even a near useless weapon a powerful tool against the horror. This is a main reason why personally handing me any form of self-defense will greatly detract from my horror feeling because I will deconstruct it as hard as I can and make it it into a strategic tool of survival.

It's a very difficult department and balance to be drawn for me because my personal play style will be able to find the worth in even the most useless weapons and make it a tool which allows me to no longer feel horror. Buff the weapons too much and the game becomes action horror. Nerf the weapons too much and why give me weapons in the first place if they're not going to do anything?