Yes, part of it is ignorance on my part. I'm not familiar with DEB or RPM package management conventions. For example, on RPM systems, it turns out you can install two RPMs of the same name, but different versions! And this is the default instead of upgrading! Boy, that took ages to debug.
But really, installing a system and using the system-provided package manager to perform a system update should "Just Work." And my experience is that this almost always ends in failure, and usually in a broken system. I dunno.
Glad you've had a good experience with Arch. I've been using Debian and derivatives for years. I've occasionally seen hiccups with apt but I can almost always trace them to network trouble rather than the distro itself. In the other cases, reading the manpages or googling a bit helped unbork the system. It sounds like you didn't exercise your sysadmin/debugging skills.