sorry if i might repeat someones answer, i did not read everything.

it seems you want it for "work" that assumes that stability and maybe something like LTS is dort of the way to go. This also assumes older but stable packages. maybe better choose a distro that separates new features from bugfixes, this removes most of the hassle that comes with rolling release (like every single bugfix comes with two more new bugs, one removal/incompatible change of a feature that you relied on and at least one feature that cripples stability or performance whilst you cannot deactivate it... yet...)

likely there is at least some software you most likely want to update out of regular package repos, like i did for years with chromium, firefox and thunderbird using some shellscript that compared current version with latest remote to download and unpack it if needed.

however maybe some things NEED a newer system than you currently have, thus if you need such software, maybe consider to run something in VMs maybe using ssh and X11 forwarding (oh my, i still don't use/need wayland *haha)

as for me, i like to have some things shared anyway like my emails on an IMAP store accessible from my mobile devices and some files synced across devices using nextcloud. maybe think outside the box from the beginning. no arch-like OS gives you the stability that the already years-long-hung things like debian redhat/centos offer, but be aware that some OSes might suddenly change to rolling release (like centos i believe) or include rolling-release software made by third parties without respecting their own rules about unstable/testing/stable branches and thus might cripple their stability by such decisions. better stay up to date if what you update to really is what you want.

but for stability (like at work) there is nothing more practical than ancient packages that still get security fixes.

roundabout the last 15 years or more i only reinstalled my workstation or laptop for:

• hardware problems, mostly aged disk like ssd wearlevel down (while recovery from backup or direct syncing is not reinstalling right?)
• OS becomes EOL. thats it.

if you choose to run servers and services like imap and/or nextcloud, there is some gain in quickly switching the workstation without having to clone/copy everything but only place some configs there and you're done.

A multi-OS setup is more likely to cover "all" needs while tools like x2vnc exist and can be very handy then, i nearly forgot that i was working on two very different systems, when i had such a setup.

I would suggest to make recovery easy, maybe put everything on a raid1 and make sure you have on offsite and an offline backup with snapshots, so in case of something breaks you just need to replace hardware. thats the stability i want for the tools i work with at least.

if you want to use a rolling release OS for something work related i would suggest to make sure no one externally (their repo, package manager etc) could ever prevent you from reinstalling that exact version you had at that exact point in time (snapshots from repos install media etc). then put everything in something like ansible and try out that reapplying old snapshots is straight forward for you, then (and not earlier) i would suggest that those OSes are ok for something you consider to be as important as "work". i tried arch linux at a time when they already stopped supporting the old installer while the "new" installer wasn't yet ready at all for use, thus i never really got into longterm use of archlinux for something i rely on, bcause i could'nt even install the second machine with the then broken install procedure *haha

i believe one should consider to NOT tinker too much on the workstation. having to fix something you personally broke "before" beeing able to work on sth important is the opposite of awesome. better have a second machine instead, swappable harddrive or use VMs.

The exact OS is IMHO not important, i personally use devuan as it is not affected by some instability annoyances that are present in ubuntu and probably some more distros that use that same software. at work we monitor some of those bugs of that software. within ubuntu cause it creates extra hassle and we workaround those so its mostly just a buggy annoying thing visible in monitoring.

You can use my post as reference and guide: https://feddit.de/post/9087676

I would also recommend checking out Distrobox, especially for DaVinci Resolve. This decouples your programs from the host OS, which allows you to run DVR on any distro and get the newest software, containerised on Debian for example.

I personally am a huge fan of Fedora Atomic, especially uBlue. It's almost the same as regular Fedora, but way more reliable and with a new concept in mind. uBlue already has Distrobox pre-installed.

"dnf -C ..." may change your life!

Maybe look into Garuda as an additional alternative to EndeavousOS and Manjaro. I'm using it on a gaming rog and haven't had any significant issues regarding stability.

It's some work and will take some learning, but perhaps NixOS.

My recommendation would be Fedora or CentOS if you want a stable workstation you won't have to reinstall. Debian is also a great choice. OpenSUSE Tumbleweed is okay but I found it a little clunky compared to the others. Avoid EndevourOS and Manjaro like the plague.