To upgrade or add an extra CPU in the mix, my fantasy is that one could add a second or third CPU into the mix, bigger RAM module, and one or more GPU's. All in neatly packaged boxes that stack.
For RAM modules every CPU plausible comes with design constraints that the RAM modules can't be more than X inches/centimeters away from the CPU package. That has to do with the extremely high speed data bus between the CPU package and the memory. Latency and signal quality are extremely important. "X" inches/centimeters often for modern memory speeds is in the ballpark of 4 inches ( 10 centimeters). Putting RAM in a module 2-3 inches away isn't practical when will have even more inches on the logic board between connectors and CPU/RAM slots.
The real issues isn't what the connecting network protocol is... running out of physical distance is the primarily issue. That's why it falls into the looney toon category. Let's change physics and then it will work..... easy to do in cartoon world.
"Snap on CPU". Again there are design limits to how far apart the CPUs sockets can be and just the multiple package links provided in some CPU models ( e.g., Xeon SP , AMD EYPC ). Those are typically in the same range as the RAM limits for primarily the same latency and signal quality issues.
Folks have built very large CPU socket number systems that covered multiple cabinets. Those are all significantly higher NUMA (non uniform memory access0 systems with custom OS kernels to deal with he enhanced NUMA impacts. Is Apple going to fork off a custom version of macOS for a high NUMA model? Probably not. Those custom CPU "glue' chips that they'd need to create to compose the high NUMA system tend of be quite expensive also. Is Apple going to try to crank the implementation costs dramatically higher? Again ... probably not.
Adding "yet another" GPU can be just be done with normal Thunderbolt v3 ( or USB4 in the future). If put the nominal 1-2 inside the Mac system and just leave the 3+ to Thunderbolt there is nothing extremely special that Apple needs to create. Apple already has deployed a system that does that.
If everything except the hard disk and GPU is in one module then it's hardly more modular than a Mac mini with an external GPU.
Hard disk? It is unlikely that any future Apple system comes with a hard disk as the default configuration at all.
If there is something likely to be chucked out of the system box into a "snap on" module that would be the hard disk(s). For example a "snap on" 2-5 bay module for SATA devices. That could basically just be Thunderbolt 3 tweaked into a "snap on" connector.
Trying to maximize it with the characteristics with Mini makes it more like a Mini. Apple has a Mini in their line up. They don't need another one. The Mini is discrete GPU less in part to keep it out of the iMac space; let alone the Mac Pro space. Gimping the Mac Pro without a GPU is beyond loopy for a
Graphical UI (GUI) focused operating system. If focused on graphics then a graphics processor is a key, essential component of the system;
not some optional widget.
The Mini has a GPU. Some folks may not like its limitations but it does have one ( and is "good enough" for a wide variety of uses).
Additionally, the notion of literal desktop stackable and high performance is highly questionable too. Controlling noise , providing independent high power , occupying smaller literal desktop footprint all get more problematical as pull the system closer to the user and desktop working area.
The Mini largely avoids that by capping the power used.