Not sure if rpis are that relevant as of now when there are so many other, usually more performant and overall compelling offers in the same form factor and upstream support to a certain degree.
I agree completely. I've ranted on this a bit on HN before but in many ways the Raspberry Pi is a victim of its own success. It more or less became the "jack of all trades master of none" for a staggering variety of projects and applications - even when it is far from the best approach. I personally cringe when I see people trying to string together a bunch of drives on a shared USB bus for a NAS application, or tryi…
I don't think this is a fair comparison. In principle, anyone could follow the hacky instructions for the Pi and complete the same project. In some cases (such as the PiHole), it might even be worthwhile.
If your instructions begin with "find a used thin client on eBay," however, then there's no guarantee that the subsequent instructions are useful. My thin terminal might not be the same as the author's, and the author certainly can't specify a single particular brand/model because the eBay stock is limited and changeable.
"Mainstreaming" a hobby project needs the standardization at least as much as it needs the performance, and the Raspberry Pi's ecosystem remains an advantage. Ironically, this advantage is the same reason that the company prioritized business deliveries during the shortage, since business use depends even more critically on the stable, supported platform.