Absolutely, and just to be clear, I’m participating here with absolutely no acrimony. One of the things that I love about this forum is that when I get into more protracted discussions, I get all kinds of interesting perspectives back and the discussions help me to solidify my own thoughts 
I think that was more true in the recent past, remains true for a very small number of users, and is becoming less the case daily.
While I won’t point at any individual user and say that they’re not capable of managing the security of their data, when looking at any substantial population the number of users who can and will make the constant effort to secure their data seems to be vanishingly small.
The automation of cataloging, discovery, bridging gaps, and exploitation has really begun to swing the pendulum away from a place where individual users are able to consistently thwart typical adversaries. I don’t foresee this trend reversing anytime soon, but I would love to be wrong about that.
Personal me watching the news sees this frequently (though less so with time). Professional me sees far, far more sees this too, but far less often than problems from individually managed systems. When you factor in data loss along with violation of confidentiality, it’s not even close.
Also, most of the breaches that we hear about in the news are (as you said) the result of misconfiguration (leaving a database exposed) on the part of the user, not the cloud service provider. (Though, cloud provider breaches absolutely do occur; unfortunately I have first hand experience with them.)
I’m not singing the praises of cloud computing here; there have been and continue to be threats associated with the use of such services, but I am pushing back on the notion that it’s wise to dismiss them outright on the basis of security and on the idea that users are generally able to outdo them.
The number of times that I’ve watched someone who “knows what they’re doing” and had “a solid backup plan” lose years worth of effort is disturbingly high. I’ll concede that seeing that a few times may jade my view of user managed security 
This field changes at an incredibly rapid pace: If you’re not constantly reevaluating your assumptions and beliefs then you’re already two steps behind your adversaries.
(For what it’s worth, this topic has been providing me with a lot of material for a conference session on the topic of burnout and depression among information security professionals
)