I'm talking about general consumer grade PC's as bought ready built from sheds. Not custom build things put together by enthusiasts.
I've had one fail on me. An Intel OEM model intended to sit as a fast cache between spinning rust in a pseudo RAID configuration. One day it not only wasn't there (taking a small amount of recent data with it) but it wouldn't respond to any advanced diagnostics tools at all.
It had become the proverbial inert brick with no detectable signs of life to BIOS, Doze or advanced Unix tools.
I prefer them in a carrier. YMMV
The most exciting failure I have ever had was when the magic smoke, sparks and then flames came out of the back of my PSU. The PC was still running at the time but it was shutdown unceremoniously PDQ.
Second most exciting was a Fax machine receiving a transmission that began smoking whilst I was on the other line. It didn't get as far as flames before I pulled the plug on it.