Perhaps the sweet spot is "stable rolling release" like SuSE Tumbleweed Slowroll or Void Linux?

In any case, I am using both Debian and Arch for 15 and 10 years and had a bit less problems with Arch on the Desktop than with Debian.

I believe the key point is perhaps backwards compatibilty, not freezing system parts; and rolling release systems seem to foster backward compatibility. To underline that: When did you worry the last time that a Linux kernel version bumb would break your system?