I have friends using Raspberry Pi as a home NAS and mail server with USB HDD and they are happy with it. For sure it is less reliable and slower than direct SATA connected drives, but reported to be stable and working fine.
In such case you can use piCore as well. Even you can set up Raid array, use a multi disk Btrfs, etc.