I feel like you gotta know what kind of games appeal to you. I'm also not into a whole lot of modern games but I got completely absorbed with Outer Wilds and Subnautica. Freely exploring a world with interesting mechanics while you try and uncover what is going on. Love it.
I also found I really enjoy Oxygen Not Included and Frostpunk. Something about making sure all my people are surviving and hopefully thriving really keeps me invested. And the little narrative things in those games are nice icing on top too.
So for games you like, like the RE 4 remake, what were the things you liked about it? Once you know what kind of things you enjoy in games it makes it easier to find more of that.