Pacman is the best for the simple fact that it's simple. APT, DNF etc get into the weeds with complex scripts trying to update databases and other nonsense that has caused apt/dpkg to obliterate systems for me too often (over like 10 years)
but pacman is about as close as possible to "unzip in place and go home" I've never had the actual pacman itself break a system. And the only broken update I've had is the stupid grub one which I solved by switching to systemdboot. On top of that even IF you somehow obliterated an arch system it's trivial to chroot in, use a statically built pacman, then reinstall all system packages with a single command.
I unironically use arch in critical production systems as i genuinely find it to be more reliable. Slap on some filesystem snapshots as a just in case for any bugs from updates (never had to use) and I have a system that is so much easier to use and i feel more confident doing updates