The only server that actually matched the performance of a Mac Studio was XEON Max series (formerly codenamed Sapphire Rapids HBM) with 64GB of integrated memory into the CPU package. the latency between the CPU and RAM is simply too big in a regular PC.

for DB's bandwith to RAM and Storage is just as important.

that's the thing. latency to RAM is everything. I would take 10x lower bandwidth in RAM vs 100x better latency from CPU to RAM.

The only x86 CPU that does this is the Xeon Max: https://www.intel.com/content/www/us/en/products/details/pro...

There are other possible solutions but they are expensive.

the problem with Macs, among other things, is lack of ECC RAM.