AMD CPU upgrade advice

I'm looking to upgrade my CPU, I don't have a massive amount to spare so I'm looking at 5600x or a 5800x.

How much difference will the 9 cores of the 5800x make to gaming these days?

I'd just like to be able to play newer games without frame drops e.g POE 2 and KCD2 when it releases.

My current specs are:
CPU: AMD Ryzen 5 2600X 3.6 GHz 6-Core Processor

CPU Cooler: Corsair H150i PRO 47.3 CFM Liquid CPU Cooler

Motherboard: Asus ROG STRIX B450-F GAMING ATX AM4 Motherboard

Memory: Corsair Vengeance RGB Pro 16 GB (2 x 8 GB) DDR4-3000 CL15 Memory

Video Card: Asus TUF GAMING OC Radeon RX 7800 XT 16 GB Video Card

Power Supply: Corsair RM750x White (2018) 750 W 80+ Gold Certified Fully Modular ATX Power Supply