That’s a big range of game requirements. CS GO and Valorant will be limited by the cpu, they are no gpu demanding and I doubt a gpu upgrade will benefit much over the 1080ti. COD Warzone is very gpu and cpu heavy and we expect Cyberpunk will be too. This is where you will see any material improvements. It’s up to you if this justifies the cost.
Generally you can say, the lower the resolution and graphic details, the higher will be the frame rates and also the CPU bottle neck. The higher the resolution and graphic details (especially with ray tracing), the lower will be the CPU bottle neck.
As long you have at least a 6 core CPU (especially something that clocks quite high), you should be fine on 1440p with highest graphics settings.