You generally have to beat Macs to death with a Mack Truck...
You've got that right, the only one I've ever had to "fail" actually still worked but was damaged beyond usability or repair. A titanium G4 PowerBook. My Lab got tangled in the charger cord, panicked and it was slung across the room, bouncing off walls and furniture. Bent the chassis, broke the hinges. I was able to get everything off of it, still functioned even in that state.
I had a late 2007 iMac fail in 2014. The power supply blew, and fried the logic board. Most of my backups were in Time Machine. Non-recoverable failure.
Funny thing about Time Machine, I discovered. The only computer that can recover backups in Time Machine is the computer that made them.
Fortunately, I had stored things like my photo files on other hard drives.