Question What's the best choice GPU out of these 3?

[Beginnerbuilder3]

I'm having a lot of trouble deciding on which graphics card to buy, and I'm hoping you guys can help me.
These are the three options:

1. MSI Gaming X Slim Geforce RTX 4070 Super 12 GB - $849.99 CAD

2. Sapphire AMD Radeon RX 7900 GRE - $806.99

3. Any 7800xt model - ~$700

Currently running a 5700xt with a ryzen 7 5800X cpu and 32Gb DDR4-3200 ram. I'm also playing on a 1080p monitor, but I'm planning to upgrade to a 1440p monitor when I buy a new gpu.
I'll be using my pc primarily for RPG gaming. Assassins Creed, Elden Ring, Star Wars: Jedi Survivor, etc.

I'm torn between buying a nividia card with better RT but less VRAM or an AMD card with better VRAM, or if the difference even matters. I wish to buy a card that'll last at least 3 years + and that'll keep up with new game releases.

I'd appreciate any advice that you could give. Thanks, from a newbie.

(Current Build)
CPU: Ryzen 7 5800X
CPU cooler: Noctua NH-D15
Motherboard: ASUS Rog Strix B550-F
Ram: Corsair Vengeance 32Gb DDR4-3200 ram.
SSD/HDD: Samsung 970 Evo Plus 1Tb
GPU: MSI 5700xt
PSU: Corsair RM 750
Chassis: Lian Lancool II
OS: Windows

 

[Lutfij]

Currently running a 5700xt with a ryzen 7 5800X cpu and 32Gb DDR4-3200 ram.
What are the rest of your specs that you'll be dropping the proposed GPU in? Please list the specs to your build like so:
CPU:
CPU cooler:
Motherboard:
Ram:
SSD/HDD:
GPU:
PSU:
Chassis:
OS:
Monitor:
include the age of the PSU apart from it's make and model. BIOS version for your motherboard at this moment of time.

View: https://www.youtube.com/watch?v=tFKhlplCNpM

You've mentioned etc when mentioning the games you want to tax the system/GPU with. Can you elaborate sans the etc?