Knock on wood, I've only had two hard drives fail on me in nearly 30 years of PC computing, starting out with a '286 back in the early-mid nineties before anything more than 28.8 Kbps modems were a thing. If I recall correctly, that machine had a whopping 5MB hard drive. :)
I won't bother naming the brand that failed; it was that brand because until this past year, it was the ONLY brand of hard drive I bought. This year I gave WD a shot for a media drive with one of their super-size 5400RPM jobs that goes to sleep far too often. Seems reliable enough, but it rarely spins up 'cause who has time for videos when there is work a'waitin'?
I'm hard on the drives, too, constantly pounding on them with builds and databases. The most abused were the ones in my media capture systems just before Y2K, and even THOSE drives lasted 2-3 times longer than their warranty period before I tossed them because they were too small to bother re-installing in the latest box.
But I do one thing that most people don't: I leave my computers running 24/7, and disable "sleep mode" on my spinning rust when I can. It is the start and stop friction that wears out bearings and causes drive failures; enterprise drives never shut down and don't fail nearly as often, despite the fact that there is really no major difference between most "enterprise" drives and most consumer drives save for the controller board and the warranty on it.