Mostly it depends on the size of your pool and the type.
My TL;DR is that enterprise drives are likely overkill and aren’t worth the extra cost (yes I can construct a cornercase where they prevent data loss but you’d need it to happen on multiple disks simultaneously, if you’re that worried spend the money on extra backup!). Anything marked RAID or NAS is fine. Don’t put anything designed to save energy into a NAS (eg: WD greens).
Appreciate the link! Will investigate.