I am yet to hear about 1 dying from a customer. But I can't give you a scientific answer to that and I've only been doing this since April. There's a whole community of people doing these upgrades. You can find them at https://macos9lives.com
That's where the hacked Mac OS 9 comes from and there are threads about Mac mini SSDs. There are also threads at https://68kmla.org
I would ask there.