I experienced another significant problem with iCloud Photos, specifically the Photostream function. To avoid hijacking this informative thread, a separate topic was created. Everyone is invited:
https://talk.macpowerusers.com/t/another-cautionary-tale-about-icloud-photos-photostream/14361