Single-board computer suggestion for home automation

So I have a raspberry pi running raspbian on an sd card, and host a website which is used for home automation. It's been running for over a year, and last week it stopped working and discovered it's was a dead sd card. Since an sd card is not very good for write cycles, I am thinking of switching for a single board computer which uses a HDD as a primary hard drive. Do you know any SBC which boots from and HDD instead of an SD card? What do you suggest?

but you can still boot from the SD card, optionally load the basic system into RAM, and store all the stuff that is being accessed constantly on an external HD?

yes, you can use the SD card in read-only mode. You can put a HDD using USB, but you can look for another solution on the net too:
https://www.reddit.com/r/MiniPCs/com...ntly_powerful/
or you can try this: https://wiki.radxa.com/Rockpi4 too.

If your RPi is a 3B or 3B+ you can boot directly from an external SSD or HDD, but it will most likely need to have its own power source, (some people have managed to boot powered from the RPi, but very few succeed).