I've had 2 sd-cards go corrupt (read-only, any writes were lost). Had a mariadb instance running on it as well. It will hold for for some time, but eventually, the card will give up.
The advice is to buy a quality SD card and backup data that shouldn't be lost to a more reliable location. S3 bucket, a local NAS or something like that. The general idea with Pi's and IoT devices is to act more as input point for data or programmable controllers rather than reliable networked storage or server space.
Since the Pi4 can boot from USB now (might still be in beta, not sure if it's fully released), I would get a USB3 to M.2 adapter, buy a decent M.2 drive, and use that. It'll take up more space than the SD card, obviously, but not that much more.
Honestly throw the thing in a bin and use an old mini pc instead. Lenovo thinkcentre tiny. You can pick them up on eBay for about the same as a fully equipped pi.
Pi is 100% not suitable for 100% duty work. It’s just a toy.
I’ve had 6 so far and all have had reliability issues or weirdness. Mostly related to SD corruption, crashing or power brown out. The power issue was not solved by running them off a proper keysight bench supply.
SD cards are quite frankly horrible boot media as well.
M600 fanless is around 15W full whack and 5.5W idle (measured). The CPU in it has a 4W TDP.
For that you gain:
Decent thermal design., A decent quality enclosure, A power supply (thinkpad brick), Two displayport holes, An SATA interface (M.2 form) for an SSD, Built in Wifi, A RAM slot you can chuck 16Gb in, 2 more USB ports.
There's no competition. I paid 79 GBP each for mine (I own 3). Pi is 57 GBP bare board.