Bloodrayne or Castlevania. Semi-linear. Prowl locales assassinating/fighting specific targets which leads to fighting the occult and eldritch abominations. But I think I just want 3rd person Action Adventure games with a supernatural or horror setting.
Open World or Sandbox games tend to be bad because too much freedom leads to boredom, no sense of direction and worthless rewards. Perfect example. Breath of the Wild and Tears of the Kingdom. Any adjacent sandbox game will suffice. Great games mind you but suffer those pitfalls.
I think the last true Sandbox game I enjoyed YEARS ago was Incredible Hulk: Ultimate Destruction. What a game that was. Stupid fun.
I think it's important to separate Semi-Linear/Nonlinear and Sandbox from what we think of as Open World. Open World is too broad a label in terms of what Gamers are actually looking for.
Games that are Semi-linear like Blood Omen: Legacy of Kain, LoZ OoT/MM/TP, Dragon's Dogma, Fallout NV, Elder Scrolls, Dark Souls 1 with lots of lore and places to explore and acquire better items and gear from are what I strive for.
Ones that have a dreamlike, surrealism that are atmospheric with impeccable level design are probably the best. And are truly hard to find these days.
March Climber
Resident Evil would work perfectly exploring the entirety of Raccoon City's aftermath but I feel this would be best done in a game engine that isn't RE Engine. The scope of exploring the city, it's sewers and potentially underwater requires an Engine that can handle that scale.