It's easy to overlook because of the graphics, but Caves of Qud is a really interesting game that fits your criteria.
It's hard to explain just what it really is or what makes it great, but it has a good mixture of generated and written content that keeps it interesting.
Not too advocate too heavily for steam (it's your pc and I get having lines in the sand) as with all things you can disable auto start and auto updates pretty trivially as far as I know.
The combat far and away is the weakest portion of TotK, as it was in BotW. They did nothing to make it less tedious. The enemies are damage sponges and weapons are brittle toothpicks.
I think long term I will think back with more fondness to the much shorter open world game without combat called Sable. That game is worth playing if you're feeling burnout and want a shorter, completable experience.
I also came across this channel by Freya Holmér recently that does more Long Lecture videos on math for video game programmers. I found the the one on splines to be quite enlightening (as I had recently been doing a lot of spline stuff and struggling with third party packages).
I first heard this joke (or some following the same format anyways) in the MST3K episode for "Overdrawn at the Memory Bank." I think about it pretty often.
Yeah, last year I finally dipped my toes in mechanical keyboarding and my 2 requirements were to have a numpad and some media keys for volume and play/pause. It was actually kinda a nightmare to find.
I have sort of an inverted souls hot take. My least favorite part is the souls games are boss fights, and eldin rings open world made the game's exploration and non boss progression too easy.
As a related note, if your computer isn't on a surge protector you should get one. They're pretty cheap and will protect your computer from power problems.
If you do a lot of work with yours, you should consider a battery backup one. That would give you time to save any work and properly shut down your pc if the power goes out.
It's ok, if you want to see some gameplay you can probably watch the previous game.