As long as you update frequently (I do it whenever I think about it, usually once every few days to a week) you shouldn't run into any issues

I've had two different arch based distros have issues when trying to update after long periods. I also had an Ubuntu server fail completely when doing a major version upgrade and had to restore it from backup. But then again I've also had no trouble updating an Ubuntu machine that was a couple years behind.

I'm on Fedora now for my desktop and it's been great so far, but I also do updates at least weekly. My advice would be if you expect to go months between updates your best choice is probably Debian.

I recently updated an old laptop from Ubuntu 16 to 24 with no issues whatsoever. Do not start with Arch if you don't have any Linux experience yet.

Honestly if you are that worried about updates breaking stuff, you might be better off using an immutable distro. These work using images and/or snapshots so it's easy to rollback if something goes wrong. It's also just less likely to go wrong as you aren't upgrading individual packages as much, but rather the base system as a whole. Both Fedora and Open Suse have atomic/immutable variants with derivatives like Universal Blue providing ready to go setups for specific use cases like gaming and workstation use.

Alternatively the likes of Debian rarely break because of updates as everything is thoroughly tested before deployment. Gentoo and void are the same deal but in rolling release format so they are at least somewhat up to date while still being quite well tested.