Found this applies nicely to my career. Routineish work? Drag my feet and fight myself to do anything. Fixing problems (bigger the better)? Everybody stand back, I got it.

Whole damn system failed due to a database failure that propagated to our secondary host too. Hacked our backup to usable in a day (meeting most requirements, including transition requirements) with a path forward for total system recovery on the main system.

Documentation on any of that though, that was a … struggle.

One thing that will be the biggest general qol for your new build is likely to get a M.2 NVMe for your games and OS

Civ 6 is pretty flexible and dwarf fortress will run on a potato, basically anything remotely in the gaming market will play them fine. Civ 7 is more intense, but being turn based cpu tends not to be the bottleneck

Do you have any preferences (distro, cpu/gpu manufacturer, etc) and a budget? Most of the games on your list I am familiar with and will run on damn near anything remotely modern.

Lacing direction, with the fairly low requirements (from what i recognize), and assuming you are price conscious id suggest you poke around the used gaming PC market (either gamer friends, or failing that online), which will also completely bypass the tariff issue too.

PopOS is pretty solid for linux gaming and has a distribution specifically for Nvidia too which handles most of the headache with Nvidia if you go that route.

EDIT: Poked around the requirement pages of the ones i wasn’t familiar with, i didn’t see a single game that had a requirement of anything newer than 10 year old hardware, depending on your friend network, you could get a computer that could play those games well for a song. Civ 7, your ‘evenutally’ game, is the only thing listed that has strongish requirements, and would be what i would pay attention to if you are aiming higher.

As written in the spell description of dispel magic, a 3rd level dispel magic also can dispel a 9th level spell with only a check, that didn’t stop them from writing some things that explicitly stated that dispel only works for that effect if cast at 9th level.