Consider this: the least reliable drive in this dataset has a 2.7% annualized failure rate at an average age of almost 4 years.
That's low enough that many SOHO users will never see a failure, yet high enough that a rack worth will have seen more than one failure recently. Thus, your question could be answered with complete honesty in both ways: with anecdotes by happy users and with anecdotes by unhappy users.
Therefore, neither positive nor negative answers are useful to you.
This phenomenon underlies the fundamental weakness of self-reported online reviews. You cannot actually get a useful measurement for how reliable a product is solely by self-reported sparse feedback.
I started my NAS in 2012 with two 2 TB Red drives. Later I added two 6 TB Red drives. Some time, around 2016 I think, one of the 2 TB Reds failed and I replaced it with another 6 TB. Then the other 2 TB Red failed, like a year later and I put in another 6 TB so they all matched. I did not get replacements even though one failed during its warranty period (I am pretty sure the 2 TB Reds still had a 5-yr warranty at that time), because I wanted to replace it with a 6 TB anyway.
Currently all four 6 TB drives are still running, plus a couple of 4 TB Toshibas I grabbed at some point.
So, I don't think that drive failure after 4 or 5 years is so bad. I got my money's worth anyway, and that's why a NAS has redundant drives.
I've had a couple of WD reds fail. You pop in another and rebuild the volume. It's normal as long as it's not too often.
I'd rather buy WD than Seagate, but that's just me. I don't really have a choice. Maybe the only people who have a choice are either in the enterprise or buying one drive every few years for a PC build or something.
The rule is to avoid all of your drive being from the same factory date/batch, even if they're all from the same brand order from different stores or whatever to help make sure in case of a defect they're not all affected.
Also for home NAS ensure you have redundancy (a proper raid level, avoid JBOD and Raid-0), and have backups. Raid is not a backup.
ZFS is great in this regard: redundancy, data scrubbing to ensure data integrity and built-in snapshotting and data replication features (zfs send-receive). Can't believe how I got by without ZFS in my earlier years of data hoarding.