It depends on your needs, but here is my expierience. I like my data encrypted, no cloud and backed up, so my config is:
1. Intel NUC + Internal 2TB NVME SSD (24/7)
- Encrypted with LUKS
- All-Day-Data like personal Photos, Music, Audiobooks shared via SFTP / SMB
- Low Power consumption + good performance
2. Dell T20 + 32GB ECC RAM with encrypted ZFS 10TB RAID 1 (wake on lan / on demand)
- FreeNAS
- Backup Server for NUC and all other clients
- ZFS Snapshots for Ransomware protection
3. Alix APU 4GB with ZFS (24/7, off site at my fathers home)
- disaster backup for my most important data
- sync via zfs send with one specific dataset from machine 2
Its pretty low power, but also low on storage - it took a while to find out that the data for my all day use is < 2TB. This is often not enough for most people...
I can recommend to use an cheap old machine as NAS with ECC RAM (a must) and ZFS, like a
- Dell T20
- HP N54L
- HP gen8.
OS can be FreeNAS/TrueNAS, napp-it or another reliable one. I never had problems with these and once configured, there is hardly any effort to maintain them.
What I don't recommend is:
- Raspberry PI based (not reliable, slow)
- Custom build (expensive, much effort)
Soho NAS like Synology are ok-ish, but I don't like them - Bad things happend to me. Broken filesystems, damaged files, non-working backups, slow performance and so on. But that was a while ago, maybe now they are better :-)