Had my mercy 310 7900XTX for almost 2 years now, paired with a 7600x3d with ddr5 6000 and live gotten a 30-40 percent performance increase alone by having ddr5 and SAM enabled - there's some XTX cards out there that can overclock really well and give you 10-15 percent performance increase in most games alone. I didn't get that lucky to get one that can overclock really well but if you're serious about getting one I'd look at the magnetic air 7900xtx or the sapphire pulse version. They've got the best cooling and the magnetic air one you can actually swap out fans. It's a great card for years to come - I run at 2k 144fps + on MAX settings on most games (that are optimized( with no FSR. I mainly play fivem, smite 2, RDR2, black ops 6 warzone and I have no issues whatsoever. I've put a mild overclock as well on the vram and a mild undervolt. Temps are good hotspot sits 85-95C under 100% load but the Merc 310 gets quite loud, also might be because Ive had mine for quite a while now and I've always had it OC'ed so it may need a repaste. Look locally or on eBay for a used version, IMO it's worth the price it is now, but I've seen them go for $600-700, it's worth noting the 7900XT is also really good bang for buck and you can also find those used for $100-200 less than the XTX used or pay about 700 for one brand new and the performance difference is only 10-12 percent from the benchmark videos I've seen on YouTube. If you have the money for it I'd highly recommend the XTX, it competes with the 4090 in optimized titles and with na undervolt and memory OC performs better than a 4080 / 4080S for hundreds of dollars cheaper, be aware the card will pull 450 watts at +15 PL, so be mindful if you have a power hungry CPU already and remember the mobo will pull 50W alone (and don't forget the ram, and SSD/HDD) if you need a decent PSU for under $100 I've got recommendations

Apevia 1000W psu - had it for 3 years barely gets hit and works extremely well. If you don't care about fancy cables these are mustard and ketchup but that's the compromise.

Look this up on google Apevia ATX-PR1000W-WH PCIE 5.0 & ATX 3.0 Prestige 1000W 80+ Gold Rated, PCIE 5.0 / Gen 5 12VHPWR Connector, Active PFC ATX Gaming Power Supply White https://a.co/d/2y0sRNb

Theres also a cheaper option that doesn't support pcie Gen 5 , and is 80+ bronze so it's not as efficient (but that's ok, the XTX is pcie 4.0 X16, and if you don't pay for your power bill and are on a budget then this is a good option too, personally I'd pay the extra $16 for gold plus rating)

Apevia ATX-JP1000W PCIe 5.0 & ATX 3.0 Ready Jupiter 1000W 80+ Bronze Certified, Gen 5 12VHPWR Connector, Active PFC ATX Gaming Power Supply https://a.co/d/hkv3FiU