Generally I would recommend the 7700x in your case.It’s 5% slower than the 9700x but 100€ cheaper. The x3D parts are nice, but due to the disappointing 9000 series their price currently is way too high.

I would generally not recommend the 7600x3D as 6-cores nowadays is a bit low and the consoles also run on 8 cores, why we have seen a bit of a push into better optimisation for 8 cores and beyond. With some nice PBO overlocking your 7700x can quite possibly outperform the 9700x out of the box and even the 7600x3D. The 7600x3D is a twice cut down processor SKU with significantly lower clocks to go with it as expected(also why the supply is so low). The 7700x outperforms the 7600x3D most of the time in normal gaming scenarios, where the game is not so small that it can completely sit in the x3D cache (like in Factorios benchmark) which is something that never happens outside of benchmarks.

Also don’t put hope into 9700x performance increasing in the future drastically, the architecture has the performance improvements AMD wanted, but they are not used in games etc. But in datacenter scenarios. The new Motherboards won’t make a difference in the performance of the CPU and will be just more expensive.

Also games you mentioned are simulation heavy games which benefit from more cores to do the simulation on, where the extra cores of the 7700x are of way bigger use than the slower but equipped with higher cache cores of the 7600x3D.