Where I think the "NAS" hardware is applicable is if you are running mission critical services (up to you to decide what is mission critical) and you want to minimize the down time.

It's certainly much cheaper to buy conventional drives, and just have a few extra that keep live or regular backs up on.

If you are doing any kind of drive RAID where you combine multiple drives into a larger pool of storage I would absolutely skip out on anything that uses SMR, and would probably justify the extra price for the NAS grade equipment, purely because of how nightmarish it can be to repair RAIDs. You'll definitely want to minimize the amount of repair and maintenance you need to do on a RAID.