Honestly: no
Two big issue: all of these Cloud services are running servers with a Linux OS, or a variant thereof. So you run into the issue of the library sitting on an inappropriately formatted disk, and the risk of corruption. Second: the risk of corruption in transmission - either up or down - remains the same. SO simply I would not do this.
That said, there was a service a few years back that would sell you a Mac mini, send it to you so you could run your first back up on site, then you sent it back and they put it online for you to incrementally back up. Can't recall the name of the company and a search found nothing. Maybe you might do better. But remember the cost includes the Mac mini...
Personally, I'm a bit OCD on backing up my photographs. Off-site back ups are very important protection against calamity. In the past I had one back up stored in my car, which I could update easily and another in a relative's house across town, which I might update every 3 or 4 months. Then I started backing up my photographs - the images not the database - to online Photo Sharing sites - places like Flickr. Very inexpensive and at least your images are safe (and accessible from anywhere in the world.) All of these services have privacy levels so you can control what other people see, of course. But for the last several years I have been using Adobe's Lightroom CC (not to be confused with their Lightroom Classic app). LRcc is a direct competitor to Photos but works differently. When you import your images they are uploaded to Adobe's servers. They all live in the cloud. So backing that up is Adobe's job. Then you manage, edit, process and access the images via their apps for Mac, Windows, iOS and AppleTV, Android etc. Of course, you have a back up off line of all your images, and nothing precludes you from also using other ways to back up. I beleive that the app Mylio offers a similar option. Both of these apps are subscription services, but they are also significantly more capable apps than Photos. You get what you pay for.