SSD and HDD are typically warrantied for 3-5 years but both usually last longer depending on use. Enterprise HDD (e.g. Seagate Exos) are designed to run 24x7 for 5 years and often last longer than that. Even non enterprise HDD often last longer under light use -- I have four 2.5" HDD from ~ 15 years ago that I keep around and they keep going.
In my experience what kills HDD fastest is being moved around especially when turned on/spun-up. Also, non-enterprise drives being run 24x7. I am not even sure some of the cheaper HDD are designed to run 5x9.
Today's pricing aside, it's hard to justify HDD for general use. SSD don't care about being moved around and they're orders of magnitude faster (especially in the last 5-10 years). Apple didn't even try to optimize APFS for HDD and has been chiseling away at HFS+ support in macOS.
But today's pricing however throws a wrench into things. Not only are prices ~ 2-3x from a year ago they are extremely volatile. I think 2TB NVMe SSD just went up 50% since my post a few days ago. For the price of an 8TB SSD, and recently it appears even 4TB, you can buy multiple very large HDD.