It's the reliability and durability that gets you
Discussion
I mean, they're used alllll the time in industrial settings. As long as you use a high quality SSD (which is kind of required anyway) I don't think the reliability or durability is notably worse than other consumer grade hardware.
I burned through three of them because of a bad ground or power failures.
Granted, I may be an idiot, but none of my computers failed during that time.
I recommend using the proprietary Pi cable and a UBS/Surge protector when possible
But yeah, three failures is no good. Just out of curiosity, did you check if the SD card had failed?
Ah yeaaa. They are very particular about power sources. Or probably just as particular as any computer, but can be powered by any crappy USB brick so they have to contend with shittier supplies more often.