Actually, you shouldn't compare cards just by price and performance separately - it's like choosing a car based only on engine power and gas costs. The main thing you need to understand: why change your 4070 in the first place if it's working fine? I know a guy who switched from a green card to a red one just because he read online that it was two-thirds cheaper. He spent about two months struggling with the fact that his main work software (something to do with video editing) just wouldn't work properly with AMD, then switched back and called it a day.
As for the 7900 GRE specifically - yeah, it's a powerful card, yeah it's cheaper, but the question is whether you actually need that performance. The 4070 is already plenty for most tasks. The CUDA ecosystem really does matter - in video editing, 3D, neural networks, and professional software, green cards often work better or faster. AMD drivers have improved over the years, that's a fact, but that's not the main issue. The main thing is you'll spend energy on switching, and then it might turn out your software just doesn't work well with AMD.
My advice: before you make the switch, write down exactly what you're lacking. If you're bottlenecked by fps in games - that's one thing, if it's render performance - that's something else entirely. And check how well AMD actually supports the specific programs you use. Maybe just selling the 4070 doesn't make sense.