IMHO, Fedora's Atomic Desktops[^1] are the way to go for that. Automatic upgrades you can roll back if something breaks? Yes, please.
Universal Blue[^2] has some spins that got a glow up, but their dev team gives a bit of the "everything old is bad" vibe.
OpenSUSE's MicroOS[^3] desktops aren't ready for nontechnical people, but their atomic upgrade strategy is much faster and simpler (btrfs snapshots). I'm keeping an eye on it.
^1: https://fedoraproject.org/atomic-desktops/