Project Zomboid is less narrative than what you’re looking for, I think, but when you start again in the same world you can find your previous character as a zombie.

Good coverage here as well https://kotaku.com/unity-engine-subscription-cost-unreal-godot-indie-dev-1850831032

Really does look like a tempting deal. Also covered here https://www.theverge.com/2023/8/8/23824739/valve-steam-deck-certified-refurbished-price-listings