imo dishonored and deathloop managed to achieve a good balance, they could do semi openworld with rogue like elements of doing operations with scripted and random events along the way, so you could progress the story in a non linear fashion. the tricky part as always is balancing, something to stop you from hoarding stuff in multiple supply runs and circumvent the survival horror part of managing tight resources.

I found a YouTube link in your post. Here are links to the same video on alternative frontends that protect your privacy:

• yewtu.be
• inv.nadeko.net
• yt.artemislena.eu
• piped.video