I'm honestly not quite sure what you're talking about. I've been using Arch as my daily driver for maybe 5 or 6 years, and I don't recall ever having my installation messed up from an update. Arch is fair bit along the spectrum of being a "build your own system from the ground up" type of deal though (although not quite as far along as something like Gentoo), so I don't doubt your experience, given how much two Arch installations can differ.
But one of those was a big compatibility breaking one that I hadn't done the prep for (because I'd missed the whole lead up for various reasons and was months late on the update anyway) and I still can't really explain the other.
Compared to Debian which I managed to break many times in the same time frame...
How did you exactly break Debian multiple times?
I've read about people doing crazy stuff, like replacing the default compiler entirely (rather than setting an alternative one) or forcing apt to install incompatible packages... and then complaining that the distribution is not stable.
Non-rolling distros are very very conservative with package upgrades, and they don't "just break", as little changes over a given version.
Alas, I can't remember exactly what happened but it was the late 1990s/early 2000s - no crazy stuff involved, just things getting confused / crashing whilst doing updates and leaving things half-arsed and broken.
I'd love to hear more detail about this, because `nixos-rebuild switch` is not capable of causing such a problem in a permanent way.
(It can arise temporarily, though, if you switch to a new configuration without rebooting, and that configuration requires a different kernel than you are currently running. Rebooting and choosing your old configuration at the bootloader menu fixes this.)
Yes, Arch requires you manage and maintain your system, it's not a "just works" thing, but that's a few minutes of work here and there, it mostly just chugs along.
As to hosing your install, I've never had even the threat of that. Yes, you should check the news before doing upgrades to make sure there isn't something that requires your attention, but it's not exactly a big deal to check an RSS feed before you run an update command.
I started using Arch back in 2011 and Manjaro (Arch-based) in 2018. Besides a day or two of initial setup, getting things how I like, I spend ZERO time tweaking or fixing my installation. Your warning simply does not match up with my experience.
I also have a Pi2 running Arch ARM at my mom's house, doing one or two updates per year when I visit her, also failed only once, and that's because of a corrupted SD card.
I'd admit I'm usually a bit nervous typing pacman -Syu on those two, but it's doing surprisingly great.
However, I stopped using arch mainly because I was working with ROS at the time, where every boost upgrade triggered half-a-day recompilation of ROS and it's various plugins.
I've tried both, Arch Linux will routinely hose your entire install if you don't carefully read the update notes every time (even if most of the time there is no call to action for you). Unless it has changed, this is still the expectation of users.
NixOS promises stability, you just walk back to a previous version! Alas, i've had NixOS hose _all_ of my previous versions because of X server issues. Not only that, but the community of NixOS is hostile to getting shit done, if its not the NixOS way please stay away,