Im far from an expert but this is how I would weigh it up.
Higher cache is better. Not sure if this thread is related to C4D or 3dsmax but the faster the single core speed the better for general tasks in 3dsmax (I would assume the same for C4D but cant confirm). Ignore the Turbo its not sustained for longer renders, does speed up the scene when doing viewport changes or general tasks, short renders etc.
For general 3D use I would put them in this order (best to worst):
1. AMD Ryzen Threadripper PRO 7975WX (128 MB Cache, 32 Cores, 64 Threads, 4,0 GHz bis 5,3 GHz, 350 W)
2. AMD Ryzen Threadripper PRO 7985WX (256 MB Cache, 64 Cores, 128 Threads, 3,2 GHz bis 5,1 GHz, 350 W)
3. Intel® Xeon® w7-3465X (75 MB Cache, 28 Cores, 56 Threads, 2,5 GHz bis 4,8 GHz Turbo, 300 W)
4. Intel® Xeon® w9-3475X (82,5 MB Cache, 36 Cores, 72 Threads, 2,2 GHz bis 4,8 GHz Turbo, 300 W)
For rendering I would put them in this order (best to worst):
1. AMD Ryzen Threadripper PRO 7985WX (256 MB Cache, 64 Cores, 128 Threads, 3,2 GHz bis 5,1 GHz, 350 W) (409ghz total/average)
2. AMD Ryzen Threadripper PRO 7975WX (128 MB Cache, 32 Cores, 64 Threads, 4,0 GHz bis 5,3 GHz, 350 W) (256ghz total/average)
3. Intel® Xeon® w9-3475X (82,5 MB Cache, 36 Cores, 72 Threads, 2,2 GHz bis 4,8 GHz Turbo, 300 W) (158ghz total/average)
4. Intel® Xeon® w7-3465X (75 MB Cache, 28 Cores, 56 Threads, 2,5 GHz bis 4,8 GHz Turbo, 300 W) (140ghz total/average)