One of the things I use my Raspberry Pi for is recording security camera feeds using ffmpeg. I record rtsp mpeg4 640x480 15fps streams of 9 cameras 24/7.
I used a 1TB portable hard drive for about 3 years, first recording from my main computer, then later hooked up to the the rpi. It died just before the warranty expired. I had it replaced under warranty, and the new one died again after 3-4 months. At this point, I began to consider the possibility of using an SD card to record the camera feeds instead of a hard drive.
It was this post by Averell from 2018 that was really useful.
He tested a 32GB Sandisk High Endurance SD card, writing 70TB, or 2187 full rewrites of the card before stopping the test (it was still fine).
I got a 256GB Sandisk High Endurance SD card about 1.5 years ago, and it's still working (as of February 2023). The camera feeds write about 40GB per day. I use the f2fs file system. I reduced the bitrate to 384kbps per stream so I can get 4 days history + the current day stored on the card.
40GB per day for 1.5 years is about 21 TBW. That's about 88 full rewrites of the card. And that doesn't include the OS writes, so the total is actually a little higher.
If it lasts for 3000 rewrites, that would be about 48 years.
This is also really interesting info I found at the time. At least as of a few years ago, they were using 3D TLC flash for the Sandisk High Endurance SD cards.