I don’t know if Flatpak can cover all the scenarios. It seems to be mostly for Desktop apps. I know Ubuntu was able to have system tools installed with Snaps though. However, having apps installed with their dependencies in one package is neat, but it takes a ton more in storage.

Flatpak is a great extra layer to have on top of a regular package manager, but I wouldn’t use it as a sole package management system.