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.





Wow. They really seem to have gotten overextended with the Urban District Market. Tried to make it feel like a multi-vendor food hall, but it was really all one restaurant with more ordering steps/hassle/cost.
Even still, that’s a lot of debt.