Wait, the Mac Studio has worse single core perf than an iPad Pro? that's absurd.
Apple doesn't make an Ultra version of the M4. The speculation is they'll do this every other generation.
Even on the x86 side, if your workloads are primarily single threaded then you will be better served by a consumer CPU than a $10,000 server CPU.
For heavy multi-threaded workloads there is no comparison.