For the "you have to update it every once in a while" problem, I built a small cronjob that automates the updates, but allows me to intervene. Source is at [1], and it talks to me via XMPP. [2]
[1] https://github.com/majewsky/system-configuration/blob/master...
Slackware and Debian are nowhere near as current as Arch, and don't have anything near comparable to the AUR.
The main downside of Arch is that you want to be updating somewhat regularly (every couple months at max). This isn't an issue for desktops/laptop I regularly use, and I run Arch on my home server that gets updated around monthly, but it's not a "set and (almost) forget" like Debian stable or CentOS.
EDIT: I run Arch on my work laptop and my home server (which runs my blog and some services) and it's never fallen over in several years. Occasionally updates will require me to do something, but if there's an update that requires manual intervention they post about it on archlinux.org.