Definitely play The Beginner's Guide. It was written by the same guy as The Stanley Parable, and it's only about 1.5 hours long. It has one of the best endings I've experienced.

Delayed response, but based on you liking Minecraft, survival type genre might be good.

Valheim and Project Zomboid are great games. Subnautica is very immersive. Stardew Valley is a lot of fun.

BTW, have you tried MineClone2 on Minetest. It's a Minecraft clone so much more fun than Minetest.

Please play the souls games.

Dark souls 1,2, and 3. And sekiro.

They are all super good

No microtransaction, good difficulty, and just fun af to play

also if you’re liking gta V you may like Red Dead Redemption 2

Hammerfight.

"In the physics-based gameplay, the player swings large melee weapons and relies on centripetal force to give the object enough kinetic energy to destroy enemies. The demo release had six main types of weapons - four melee and two ranged.

The different weapon types offer a certain variety. To be a slow, but well-armored powerhouse using hammers or maces to deliver slow, but crushing blows, or a nimble, but poorly protected sword-wielder, delivering quick, but weak attacks, is entirely up to the player. The game also contains a few different play modes, such as a hunt on worms or a Hammerball game."

Not a specific game recommendation, but you should look into Xbox game pass. For $10-15 a month, you get access to a huge library of games. You'll be able to try a bunch of stuff without having to commit to any purchases. https://www.xbox.com/en-US/xbox-game-pass

If you can get Saints' Row 2 or 3 working you may like them.

I know you don't like management games but you might still enjoy Frostpunk as it's a bit more like an RTS since it's about build order when you really get down to it. It is apocalyptic but it's hopeful rather tgan depressing (for the most part) or "haha you can do anything cus no laws".

Man your list of nos really eliminates most of my repertoire… :P Have you considered XCOM, XCOM 2 or XCOM Chimera Squad?

Oh! Prey (2016) is a good immersive sim you might- oh it's set in a space station, nvm…

Ah! Okay, this is a space game, but since you liked Stanley Parable you might be okay with this… Outer Wilds. Don't look it up, you'll spoil it. Just get it and play it, seriously. Get it on steam and use a timer so you can refund it if you hate it, but you really really really need to give it a shot.

If you liked red-alert you might like other RTS games such as Age Of Empires 2 (remaster came out in 2019, very active community) or starcraft2.

Have you played any of the Red Dead Redemption games? The second one is on PC and doesn't require digging out an xbox 360/Playstation 3 to play the first if you don't want to. You may find the story of the second slightly more rewarding if you are able to play the first, though, as the second game is a prequel to the first. Both are some of the best stories in video gaming, imo.