My recommendation would be Debian + Flatpak & Appimages (or + Snaps if you’re the devil). Super stable, but also access to the latest.
Fedora is also a middle ground too, but they’re pushing flatpaks heavily so it might not matter anyway since Fedora + flatpak and Debian + flatpak are about the same.
In all reality it’s fine. Snaps are annoying on occasion, and the Amazon search integration was rightly riffed on, but it’ll work like anything else. Sometimes it’s just funny to riff on Ubuntu, and sometimes people hate on it because Linux people are very … er … um … opinionated. But if it works best for you then go for it.