I don't think the Mac Pro is a disaster btw, it's just reflective of a narrowing of the focus of Apple's technology towards consumers and the many groups of professionals who don't have somewhat esoteric needs.
From my point of view, the Mac Pro is targeted to professionals who have esoteric needs.
I develop software that runs in the data center. The average cost-effective computer, when tailored to our needs, has 64-128 CPU cores and 1-2 TB RAM. (AWS calls those memory-optimized instances, and they are much cheaper than the so-called high-memory instances.) Because the individual jobs are almost always smaller than that, the development environment can be smaller, with maybe 32 CPU cores and 512 GB RAM. That could be a workstation or a dedicated server. Or even a cloud instance, though the cloud can easily become the most expensive option.
When I think of a workstation, it's basically a scaled-down version of the average cost-effective computer. Something with CPU cores, memory, storage, and network, and any GPU that can handle 2-3 monitors. There is no particular need for powerful GPUs, fancy special-purpose accelerators, or PCIe slots / Thunderbolt ports for connecting obscure devices.