Wholly depends on how much stuff you’ve got. I’ve started having issues with the Linux io scheduler when the auto backups got large (1G+), the thing just hung and needed a power cycle.
Also what SD card you have, the durability between different models differ a lot. The SD card I use for my dashcam been working for years (A "SanDisk MAX ENDURANCE" card), some other cheaper SD cards can stop working properly after just months if you're using them for write-heavy stuff.
Anecdotal agree, but I only use it for my lights (about 20 smart bulbs + 5 sensors + 4 remotes) and I never tinker with it. At least 4 years later, that little Raspberry Pi 3 + ZigBee dongle + sdcard are kinda forgotten about.
Interesting; my Raspberry Pi 3B+ + Zwave dongle + SDcard eventually got too slow (to the point that HAOS updates would fail). Switched it to an old ChromeBox and it's been no problems since.