While not the biggest library, it’s approaching the point where I’d need to start buying upgraded storage on any new Mac I buy, or use external storage for my Photos library. One of the things I like about iCloud Photos is my computer doesn’t need much local storage, Photos will manage it, downloading full res images on demand and purging them as needed.
I’d want a backup solution that is optimized for this, to allow for backups of the originals, without having to have them all downloaded all the time.