timmmay:
Interesting about cards. I have a new Samsung card which should be fairly reliable, and have Sandisk as well. Do you have an easy way to do a snapshot of the SD card over the network? It will be in a somewhat inaccessible physical location. Looks like image-backup might do the job.
I haven't used Zigbee but I imagine it's more reliable than WiFi. I have no Zigbee devices though.
I'm no expert in this, but from my (limited) understanding it's too many/continuous write operations. You will have no issues if you're just experimenting, but if you're using it long term you need to be a bit leery about hammering the log files or continuous database logging. High endurance cards (designed for security cameras) can help, and there is lots online about using a database on an external USB or similar. You might like to have a read of:
https://community.home-assistant.io/t/ha-corrupted-another-sd-card/195073
https://community.home-assistant.io/t/sd-card-corruption-problem-couple-tips/95596
HASS has a built in backup feature. I now make a point of making a snapshot before and after every time I tinker with a config or add a device. I also make sure I download a copy of the snapshot when I do it (you can do this all from the web UI). There are also various plug ins to do backups automatically and upload it to your choice of cloud provider but I have never quite managed to make it that far down my to do list.
Just FWIW, my long term (bulletproof WAF) solution to the SD card issue was an @xbmcnut NUC running HASS from SSD 👍. But a RPi will be perfect to take you a long way down the home automation path. HASS's UI is _really_ good now, especially when I consider what it was once like.