It can be whatever you want, if you want it only for documents the disks don’t need to be to large, it can even be NAS SSDs (depending your backup model), but considering the office apps requirement I also think synology is a good option.

There is also Synology photos and I like it but see a lot of people recommending immich, someone that has used both know if there is notable difference or benefits?