My proposition would be universal across every distro. Be it CLI or GUI, Debian, Fedora or Arch. As long as it uses the Linux kernel and adheres to the FHS, this type of installer wizard would work. The Linux kernel is what executes the binaries, and FHS is how you deploy the software. /opt is there exactly for installing software like this. Software can check if it's invoked from the command line or from a GUI and launch the right form of an installation wizard so you don't need a DE to use it, and you could bundle both variants in the same installer binary.
Most importantly, this would give software developers one way to be able to distribute their software across all distros, which would incentivize more support of Linux, which is something Linux users want. This has always been the big problem, that again, even Linus Torvalds said is a problem that he personally experiences, where AppImages are the next best solution but somewhat restricted, and Flatpaks are much like Wayland, an overengineered solution to a simple problem, and the one universal minimal solution has been there ever since the Linux kernel was a thing. A binary that unpacks the software to /opt and symlinks it to /bin or whatever the best way to have it seen by the system is.
I don't see anything controversial with this approach. If you don't like it you could just not use it. Just like you're not forced to use Flatpaks if you hate how complex they are. I just think this would be the most elegant and minimalist idea for software distribution on Linux.
its important to remember just because a package shares the same source code with upstream the package itself is maintained and updated by the distro, so it doesnt matter that apt isnt the same thing as dnf. the package is still a debian package or a fedora package
This "the distro maintains the package" is another major issue. The distro maintainers don't have to maintain a package for something like a web browser, or any package that isn't a fundamental system package that needs to be tailored to a specific distro. It's the reason why people don't like Debian for example, it makes
every package outdated, even something that realistically doesn't need to be kept that old, like Neovim. Flatpak solves that, and works across all distros, but is overly complicated. AppImage, also, fixes that, but it can't automatically update and it's restrictive in it's packaging. But both Flatpak and AppImage prove that no, the distro doesn't need to mandate which packages and which specific versions you can or cannot install, because they will simply work, they're pre-compiled binaries that don't need the distro's special sauce to run. And by doing what Windows does, which is throw all the dependencies with the program, disk space be damned, that solves the issues that mandate the distros to babysit the package versions of all software.
Let's face it, apt, rpm, pacman, Linux's package management is flawed, and with how popular and praised Flatpak is it's not a theory, it's a fact, since Flatpak fixes those issues that stem from Linux distros insisting on doing things in a more convoluted, restrictive way for benefits that might've mattered in the 70's when Unix was a thing, or 90's when home computers were yet to see 1GB of disk space, but nowadays 256GB gives you more than enough buffer space for redundant dependency binaries. That's the only real issue classic package managers solve by introdusing all the problems Flatpak/AppImage solve. And the way software works on Linux is not that different from Windows. It's a binary, that links up to dependcy binaries if it needs to, and the kernel runs the binary, so nothing's stopping anyone from creating installation wizards for Linux.