It’s been 4 years since I built my last one, but I still think it holds true.
I’ve heard Intel chips still run hot, especially the 14th Gen i9. However, I came across this article by Puget Systems (a system integrator who mainly deals with professional workstations rather than gaming rigs) who found that decreasing the PL1, which I assume means Power Level, from 253W to 125W was a good enough tradeoff for performance/heat that it’s the default configuration they ship to their customers.
On the other hand, they still do mention that tasks such as UE light baking, V-Ray, Cinebench, and Blender saw gains of 10-18% when using the higher power limit, which seems much more like what OP’s workload is. Puget then proceed to recommend a CPU with a higher core count like a Threadripper PRO for those kinds of workloads, so perhaps OP really would be better off going AMD for their workstation.