tbh, you need to be asking in the main forum section as, apart from a few strays, Model 3 UK wise has got insufficient time to know what works long term. A device working for 6 months is meaningless, when warranty wise it should be lasting at least 11 months+ depending on usage patterns and many years if used 25% of the time, not an unreasonable ratio.
The interesting ones are the failures, which may well be expected to occur on some less specialised types of device already if TeslaCam is on 24/7.
But in answer to your question, for TeslaCam I have a pair of 128GB Sandisk Endurance micro SD cards that I rotate at my leisure, a Sandisk Extreme card for audio files, and a dual card reader on a 4" lead velcro'd to underside of phone shelf. tbh, I would be peeved if I didn't get a few years out of each, but I expect they are a commodity item which WILL fail at some point. But at £25 a piece (reduced from the £30 I paid), a tenner a year and a spare on hand is pretty reasonable expectations.
I had a few teething issues, but since changing the program that I used to format the cards and stopping the reader flapping around loose, the only issue since then that I had was the odd folder corruption which can affect any device and seems to be the Tesla running a scan disc and not liking the state of the card that Windows PC has left it in, even after telling windows not to fix the card, or, not waiting long enough to remove the card after turning off dashcam - my SD reader does not have an activity light.
