I made the same move recently. I had the benefit of a couple of machines for testing, and lots of time since I’m retired. Beyond trying various system install options, I tried nearly every possible permutation of app installs from purely the official repositories to purely flatpaks.
I use several of the apps on your list and have had no issues with any of them.
When it came to the final setup of my daily driver, I had settled on a hierarchy of 1) Official Repositories, 2) AUR, 3) Flatpak. I chose this not as a technical matter, but just in case suppport was needed here.
BTW, working from the terminal is a highly prized skill around here, And is usually the first advice given. But with dyslexia and dysgraphia, I have a really tough time typing accurately. So I use the GUI version of pamac (Add/Remove Software) which works a charm. A single search reveals all the installation choices for a given app. Just pick the one you want.
Something that wasn’t clear to me immediately, was that you can just iterate through multiple choices and selections, then apply them all in at once. Search, choose, search, choose, and so on, then click apply when done. There’s also a little greater-than button near the Apply button that switches you to a terminal-like view so you can monitor what’s going on. The progress bar in the GUI side appears to stall when building AURs, for example, where the terminal view shows that, no, something important is really happening.
You may also run into those who are of the opinion that the AUR is no place for beginners. As you’ve found in the posts above, others feel it’s appropriate given knowledge of how it goes beforehand and what to look for. I heeded the don’t go there advice about the AUR for a while, then found that for me, it made more sense than Flatpaks. And while there is potential for danger there, it’s really no greater than anywhere else, IMHO.
Had one issue with an AUR which hadn’t been maintained in a while. (The GUI version of pamac will show you the dates.) I just removed it and used a Flatpak.
I had one issue of a Flatpak that was buggy. I found out it was built for Qt5 and I am running Qt6. (I use KDE.) The AUR version builds for Qt6, and it’s worked just fine.
HTH!
Added: The Stable Branch is closest in concept to the stock Ubuntu PPAs, but updated somewhat more frequently. If you are used to using alternative PPAs for the freshest versions, then the Testing Branch might be a good choice. (That’s where I am.)
Start with Stable and run it while to see if it’s fresh enough. (It will be fresher than stock Ubuntu PPAs.) If you want fresher still, switching to Testing is straighforward and well documented here and in the Wiki.