Perhaps the coolest Personal Super Computer was the one shown by the good folks at Penguin Computing. It was rumored to be over-clocked and featured liquid cooling for silent operation!

http://www.penguincomputing.com/products/linux/workstations