I have Sun Ultra 60 with dual Creator3D graphics, two 10k SCSI drives and I also have two CPUs for it, but for some reason I faced some stability issues with two CPUs, perhaps due to some NVRAM or Solaris configuration nonsense and which there are zero information available anymore, so there is actually just one CPU card inside currently. This configuration nonsense is one of the main things with many of these machines, they are really obscure and as they weren't sold for consumers, there really is very little information available in the internet from back in the day. Most information you will find are scraps here and there from people who try to revive these things.
I have had it for dozen or so years and after going thorough the pain to get it working properly after piecing enough of information from different sources of other Sun models and going through obscure FTP sites hunting for files, I haven't turned it on since initial tinkering and can't even say if it works nowadays. Although build quality is absolutely amazing and hardware is astonishing, it is the most boring retro box I have. The reason is that there is just so little interesting software available for it anymore. This blog post perfectly describes the software issues with many of these machines:
https://www.osnews.com/story/135605/the-mass- … x-workstations/
Besides having very little to do after the initial tinkering and wonder, after all, tinkering with different Solaris distros just gets old quite soon, these can't be used for home lab or home server either. They are just too slow for any practical use case, it is better to just use RPi and you have much, much more performance with a small fraction of power consumption while having better software availability. Not to mention the performance you get from some "real" server that is even remotely modern. And for example this Ultra 60 is just too damn loud. It has very heavy duty cooling, which makes noise, but the most annoying things are the 10k SCSI drivers which always get loud after they have been used for a while. You don't want to be in a same room with this system too long, the whine just gets irritating after some time.
While there are probably differences between all these Unix WSs as far as issues and challenges go, I'm personally not interested in getting another one or I wouldn't pay close the price they usually ask for these nowadays (I got that Sun for free back in the day, so I really don't complain). I'd say if you get one very cheap, why not see for yourself what's the fuss about them. Just be warned, many of these systems use heavily proprietary parts and design, so you might have useless box if you miss some accessories. For example Ultra 60 uses its own proprietary keyboard+mouse and AFAIK you can't even slap just any SCSI CD/DVD drive on it, it needs to have certain firmware in a similar fashion as many gaming consoles have.