Well as long as you’re aware of the risk and prepared for it, its not so bad to run in a volatile way like that. I ran my TN box for almost a decade on the same USB boot before I finally caved and picked up three Intel enterprise SSD for the job, with one as a cold spare. Nothing in the vox was critical or would be missed for more than a few beers of crying.
OP asks about HDD technology, and somehow you found a way to ignore the main ask of their question, AND offer a response including a discussion about a hypothetical home renovation.
“I see you want to know X, but I know about construction, so how about Z or Q? Eh?”
Bravo.
OP, WD Red NAS drives are usually 5400 with low cache and go at least up to 10TB. Might have to buy soon, as I don’t see much new stock.