The way I see it, the issue here is that everyone is trying to solve packaging from the developer perspective. I understand why they do, but the only way to solve this is to instead look at it from the user’s perspective.
Apps should be dead simple to find, dead simple to install, dead simple to maintain and use, and dead simple to remove.
This is why snap and flatpak and appimage are things. The problem here is that they each have various issues within them that break one or more of those tenets from the user’s perspective.
Trying to resolve packaging by going back to same methods that have existed for decades and wrapping them in a bow may help developers in some fashion, but the end users are still going to lament dealing with apps on Linux because it’s not solved — for them.