IMO it's more interesting just how dated the technology is. DEC and SGI made huge super-expensive machines (by modern standards) and I'm typing this on an iMac Pro which is somewhere between 1000 and 10000 times faster than a VAX 11/780 and would easily leave an SGI Octane in the dust.
Even knowing Moore's Law, I don't know how many people expected that kind of progress back in the 80s or 90s.
Now just imagine what a modern SGI Octane with all its custom silicon implemented in 10nm, with a modern MIPS processor built with modern technologies could be, every component finely tuned to work with all others into perfect coordination.
How would it compare to a PC assembled from generic components?
I suppose when '7nm' and smaller processes are economic enough for non-primary CPUs, hopefully also with rad hardened designs ready for use in the new space age, there will be interest in making both basic compute SoCs already optimized like this, and supercomputers constructed from variations on the same components.