Flatpaks are pretty great for getting the latest software without having to have a cutting edge rolling release distro or installing special repos and making sure stuff doesn’t break down the line.
I use Flatpaks for my software that I need the latest and greatest version of, and my distros native package for CLI apps and older software that I don’t care about being super up to date.
My updater script handles all of it in one action anyways, so no biggie on that either.
Flatpaks are the best all-in-one solution when compared to Appimages or Snaps imo.
I use Nobara with KDE for my gaming computer, Mint with Cinnamon for pretty much everything else.
Mint is the closest to a “Just Works” experience for me. Cinnamon is rock stable, especially on Mint Debian Edition. I don’t remember the last time Cinnamon crashed or had any major bugs for me.
I use Debian for most of my servers, stable and simple. Arch on a junker Thinkpad to test and mess around with new programs and window managers.