Funny enough, RE4 had a similar atmosphere, but of course that doesn't count because it had more action.
No.
If at all, only for like 10% of the game. Yet the way the ,,classic" horror segments are presented became weirder and more blatant on each walkthrough. You spend all that time on big battlefields, gunning down tons of cannon fodder. During the beginning, the intent was to create panic, but even that is a completely different mood from the previous games. By the end, obviously it's just a shooter.
Only during a handful of occasions, the mood changes to traditional horror. Which was always very akward, especially since it usually happens after entering a single door. On one side you have a battlefield, on the other side, just from one second to the next, there's not a single ganado to be found. Music changes from ,,thrilling" to typical ,,low key" for one or two bigger ,,scary" enemies and 10 minutes later you get back into the battlefield, as if you had entered a completely different game.