Debian-Testing (Trixie) is the way to go. It’s a rolling release, but it’s very stable, because packages end up there after being tested in Sid (their unstable rolling release). Whatever makes it out of Trixie, ends up on the normal Debian. I’ve been running it since April without any breakages.
I don’t like snaps (nor flatpaks for that matter, they’re too big for my slow internet connection here in my Greek village). But I find it absolutely, 100%, crazy to install gimp and darktable via snaps, and not being able to print (the print option is just not there, because they’re snaps and somehow they haven’t implemented that for these apps). As an artist who sells prints, this makes the whole distro completely and utterly USELESS to me. Sure, they can be found as deb packages too, but they’re older. And Firefox is also sandboxed. And when I installed Chromium from the command line as a deb, it OVERWROTE my wish, and installed Chromium as a snap too.
So, no ubuntu for me. The only advantage it has is that many third party apps (usually commercial ones) that release binary tarballs or appimages have tested with ubuntu and they usually work well (minus davinci resolve). I don’t have a big trouble with appimages as they’re generally smaller than the kde/gnome frameworks that flatpaks/snaps use, and they’re one file-delete away from getting rid of them completely. They’re just more straightforward.