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.