I agree with you about the sd cards. But pi 4 and higher can boot directly from SSD (in a usb enclosure, or for pi 5 via pci-e add on card). It takes a lot of the pain out of hosting on pi. I also still have an old pi 3b chugging along as a NUT server running off an sd-card with a read-only file system - another solution for the card rot problem.
And they are still lower power then anything x86. For me a mix of both pi and mini-pc work great.
I agree with you about the sd cards. But pi 4 and higher can boot directly from SSD (in a usb enclosure, or for pi 5 via pci-e add on card). It takes a lot of the pain out of hosting on pi. I also still have an old pi 3b chugging along as a NUT server running off an sd-card with a read-only file system - another solution for the card rot problem.
And they are still lower power then anything x86. For me a mix of both pi and mini-pc work great.