You want the RBG stuff so my point may fall on deaf ears: I would cut the cooler costs substantially and get a 4080. The 4080 SUPER is supposedly coming out in a few months but that is a long while away possibly if you need it now.

If all you play are MMOs, the 4070ti should be good though. I think your current rig is actually officially support on WoW to this day, even if on the slower end

I went from 3700x to 5800x to catch a sale and one generation was not enough to justify it imho. I am considering 15th gen though with DDR5. Especially since I have gotten back into MMOs, which can really put a single-core to the test.