Really my best advice is look at any performance data you can find relevant to your uses. If for example you play games where 3D cache doesn’t help for example (because some don’t) or faster memory is a bigger benefit then Intel is the better choice. If you exclusively game and most benefit from 3D cache, 7800X3D is better. If you do more concurrent stuff it’ll depend how deep down the rabbit hole you go and what you want to pay between i7, i9, 7950X, and if you really want to go deep into process affinity or game when not being productive then maybe 7950X3D.

I went AMD after my last 2 builds were Intel specifically because I do stuff with containerization and Intel has been subject to considerably more relevant CVEs than AMD the last several years (and it’s still happening on newer generations, just AMD is also starting to have their own) so I both have security concerns and would be risking notable performance to patches that other people might not need. Plus I also sometimes game while waiting for building/testing so I actually benefit from the weirdness of my 7900X3D , but I also have a decent amount of scheduler tuning and some process affinity presets for other applications that I switch between via shell scripts. I would not recommend doing similar unless you really know what you’re doing.