I'm not the unsuspecting dupe that devs are targeting to get a new user tricked into something. I'm very much aware of the shenanigans devs try and pay attention to that shit from the go.
Having said that, I do read the crap and choose no where necessary. People just haphazardly pressing okay to get to new shiny almost deserve whatever they've agreed to. I say almost because these dialogs can be worded like "Vote No for Yes" kind of BS.
If you're one of the asshat devs FUCK YOU for making this a thing we even have to discuss in the first place. Edit: Royal You Devs
And yeah.. The cloud is just someone else's computer. Would you store all your stuff on your friend's computer? Well most people store everything they have on the computers of people they don't even know...
I'm speculating here, but I wonder if part of your experience is based on the fact that you're a long time user. Features like auto-uploading to Photo Library are new, and Apple is generally decent about informing you of new features before opting in.
Brand new account setups are a different story. You're encouraged to use all of the latest/greatest stuff (and why not, current topic notwithstanding?).
Bottom line: it's extremely easy for an average user to start uploading their stuff without really realizing it.