I had a 4790k with a 1070. I upgraded to a 3070 and definitely noticed some improvement.
Then I changed platform to a 7700x and it was like I’d upgraded my GPU again.
A 4790 cripples a 4070s.
Yeah anything more than a 3070 is going to be massively wasted on a 4790K or similar - even then you'll see up to 20% or so bottleneck from lacking CPU grunt in some situations but overall I'd say up to a 3070 is worth it - especially in anything using ray tracing there are some benefits which offset the CPU bottleneck in pure rasterisation, beyond that it is a waste.