For Photoshop, Premiere Pro and After Effects Intel seems to do a better, mainly because of things like Quick Sync and faster single-threaded performance, so even a cheaper 13700K would be better. If these applications are not the main concern, Ryzen CPUs would have great performance already, an i7-13700K would be cheaper, but if that's not the main use of this system I wouldn't care about it.
Applications like Cinebench R23 (LTT Test, HUB test, Puget Systems bench) - (R23 multi-core CPU rendering, I would say this is valid for all Maxon produts, such as Zbrush and Cinema 4D) - Both AMD and Intel are great at it, for both single and multi-threaded performance, but the similar priced 13900K and 7950X would be a lot better than the 7900X3D.
3XD CPUs would be a bit better for gaming, but not the 7900X3D, that would be valid for the 7800X3D and the 7950X3D, the 8-core per CCD ones, 7900 is 6 per CCD.
For things like V-Ray (if you use that, or something similar that favors raw performance), more cores would be better, but the 7900X3D would be similar in performance to a much cheaper Intel i7-13700K or Ryzen 7900X
For everything else, unless you have a scenario where it's not dependent on raw performance, but things like Intel Quick Sync or similar, i would say the I7-13700K or the 7900X (non X3D) would be better CPUs around same price.
If you have any use for Quick Sync and where it's applicable go Intel, if not, go AMD, it has support for future CPUs, AMD should release at least 2 more generations for the AM5 Socket.
For gaming purposes i would say both Intel and AMD are on a good place, i wouldn't spend the extra money on a X3D CPU or a i9, instead (for gaming), i would grab a better GPU
For GPU performance, if you need more of it, the RTX 4070 should sit around the RTX 3080 and RTX 3080 Ti in gaming performance, since that's an average of a few games i would say it could also translate to 3D Rendering performance and raw GPU performance (and ray tracing performance).
V-Ray, OctaneRender, Maxon Redshift, Blender, Unreal Engine
If the RTX 4070 is enough go with it, if GPU is the most important thing for you i would reconsider the CPU choice and go with a better GPU, and a equally good CPU (i7-13700K and Ryzen 7900X (non X3D)
So... ~$400 Intel i7-13700K and Ryzen 9 7900X would have similar performance for productivity. If the 7900X3D performance in those applications is more than enough for you, grab either the 13700K and the 7900X instead. If you have the $580 for the 7900X3D, go with the i9-13900K or 7950X instead, both are going to be much better at those tasks (and also gaming)
And if you have any use for Quick Sync go Intel (or AMD if the main applications you use benefit from AMD)
For AMD:
If you have use for 4x M.2 Slots grab a X670E Motherboard, also if you plan to keep this platform for a long time and upgrade CPU, GPU and SSD to flagship products, maybe the PCIe 5.0 on the X670E and B650E will also help. If you have no use for 4x M.2 grab a B650E if you want PCIe 5.0
Check the ASRock Steel Legend (B650E/X670E) or the X670E-PRO if you are going white build
If you don't have any use for a f'ton of SSDs, just want something cheaper, grab a B650 motherboard instead. X670 (non E) won't bring anything useful or worth it versus B650. B650 Motherboard are cheaper, already have overkill VRMs for the 250W 7950X, so anything else AMD releases in that power range, and above it's going to run.
Check the MSI B650 Edge if you are going with the white theme
One more thing, I would go B650, i don't see a reason to buy X670E, it's too much, maybe in a few years we will have PCIe 5.0 only motherboards for $200, so i would skip the current top of the line.
For Intel:
You need a Z790 Motherboard, there's no way around that, something in the $230-260 range would be more than enough.
For RAM:
AMD really likes something around 6000MT/s, can be CL30, CL32 or CL36, for 3D rendering i don't think frequency or latency will matter.
Intel also goes well with 6000MT/s, but for the same price you can get 6400 CL32 kits. It won't benefit you much, but for games it might give a tiny little boost on some of them.
I would also look for 2x32GB kits, not 2x16GB, Video editing and Photoshop can benefit from more RAM, so it's a nice to have.
Storage is good, but for $130 you can get a 2TB Samsung 980 Pro or a 2TB Crucial P5 Plus, i would say more would be better. both SSDs are really good and really fast, i don't see why buy something expensive, when for $20 you can get an extra 1TB with a already really fast SSD.