If you’re the type that likes to max out performance with your system by maximizing cooling, overclocking, tweaking memory, etc then Intel is probably what you want. Intel CPUs draw a lot more power than the AMD X3D cpus but they’re also capable of going quite a bit faster than stock if you can tame the heat and get fast memory to run.
I’m on a 7950X3D right now. It’s been so great so far but there’s not much you can do to get big improvements over stock performance. You could undervolt but there’s still a hard cap over the boost speeds. Some motherboards can allow more tweaking but it’s a lot of work. So even with great cooling, don’t expect much more than stock performance. AMD processors currently also don’t benefit much from faster than 6000 ram.
I think the 7800/7950X3D is a big leap from the 5800X3D. 2700x to 7800X3D probably feels like a console generation jump.