If I were building a house with unlimited money, I would build a room with a supercomputer and each room would have an I/O panel to connect a terminal to. Set it up like a cloud computing setup but all local, dynamically assign compute to different users. Basically run each terminal as a VM.
This way, you could access a super computer from anywhere in your house (or even remotely), and you don’t have to listen to annoying fans. And, assuming you don’t often use the full power of the server, the upgrade cycle would be longer than having multiple machines for different workflows. I also think this kind of setup makes a lot of sense for a young family