A $500 Dell T20 Xeon has ECC memory for FreeBSD and ZFS, with room for four drives.
1TB of space on Google Drive is only $120/year in opex and zero capex.
Different people put different market values on privacy of data from 3rd-party cloud providers.
In the market segment which includes HP MicroServer and Dell T20, capex and opex can be amortized over other workloads, using virtualization for NAS VM, router VM, desktop VM, etc. People in this segment may have sunk costs in existing hard drives.
There are plenty of places where self-hosting makes sense. 1TB is not one of them, but many other sizes are.
it will limit how you can use that space. (file size limit, etc)
it will require spyware apps to be able to upload photos