In my experience, even using good quality SD cards and tuning the available settings to ensure that SD card access is minimised as much as possible, the SD card still takes quite a pounding and will fail eventually. And of course it’s always when you least expect it or want it.
I now run a number of RPI4s in various locations and all are fitted with the Geekworm x825 based kit and a good quality SSD…
Pete.