I definitely find games with psychological horror to have a better effect if done right. Making the player use their imagination to help create their own horror and making them more involved in a way is more my cup of tea. Silent Hill for me is the best with games 1, 2, and 4 especially. Other games like Haunting Grounds and Clock Tower 3 were surpringly good I thought.
Resident Evil was never really scary but had some tense moments. The only jumpscare I can remember is the damn dogs jumping through the mansion windows. From 4 onwards Residental Evil became an action game with horror elements imo.
Jumpscares for me are just lazy and no effort for the most part. After it happens it passes within a few seconds. That being said, so many jumpscares, especially in movies, are the most predictable shite ever and kinda take me out of it. Gore horror like Saw doesn't do much for me, in fact after a while it's almost comical in how absurd it gets.
This is someone who grew up scared shitless of Freddy and even fucking E.T