I'm a fan. It's not the best-looking case I've ever seen, but it's not bad compared to some of what the industry produces these days. I'd add some mesh filters and ports, but that's just me. Impressive engineering from a consumer.
Heat pipes can make noise, sure. Is it preferable to a typical setup with fans? Hard to say - if I'm using headphones, then I'd probably prefer heat pipe noise to the constant low-level white noise that I'd notice during the quiet notice of games. Still, even fans have been improving over time, growing quieter, and fan curves are easier than ever to set up (not that everyone does, obviously).
Seeing creativity in the PC creation space is always a positive in my view. Ultimately, the holy grail of computing would be to have a powerful PC that generates zero noise. The industry keeps taking steps forward, then other steps back. Heat pipe and fin geometry improve, Intel raises chip power. Fans grow quieter, and we end up with GPUs that need more air flow. Dies shrink, we raise clock speeds. These things are unrelated, not meant to be presented as cause and effect. Just examples.
But every time I see this kind of content, I get excited. It shows us how people are trying to innovate towards that goal. These solutions won't be realistic for everyone, but the concepts sometimes make their way onto the market through Kickstarters or through companies who see the potential in ideas like this. The concept cars at auto shows never make it onto the market, but many of their features eventually become mainstream. My hope is that articles about silent PC builds like this will encourage various part manufacturers to consider how they could fit into this future, and eventually make it happen.
If that day never comes, then chances are I'll end up building a PC with a home heating radiator like Linus Tech Tips did in 2018. Anything for that perfectly silent experience where the only sound I'm getting is intended to be part of the gaming / cinematic / work / whatever experience!