I can't comment deeply on deb vs rpm, it is kinda disappointing that we have this split, and I don't know if there's a great way to merge it back.
Mac does have a good distribution story. This also exists on Linux in the form of app images. The one missing piece is that Mac has the Applications convention. AppImageLauncher[0] solves this, but really it would be good for Gnome/KDE to just integrate this concept. That gives the (important!) "have the application show up in the application launcher" option.
I do not believe one could qualify Windows programs as being distributed as a single binary. A single installer, perhaps! But many Windows programs dump files all over your file tree to do things, and then goes to touch stuff in your registry. There's a reason we have "portable executables" for windows as its own download option!
* A desktop package that isn’t a vehicle for ads (like Windows and ChromeOS).
* A desktop package that doesn’t require you to write your own one-off scripts to work around stupid deficiencies (like GNU/Linux).
* A desktop package that doesn’t constantly throw away all its “legacy” and break a bunch of stuff (like Mac).
Scroll down and you’ll see people arguing about supported features because they’re running an ancient version of Thunderbird supplied by their distro.
You can do this on Linux, too, be it by compiling a static binary or bundling everything as an AppImage or what have you.
Frankly, I find it annoying that it isn't done as a matter of course.
I think it's unfortunate anyone offers .deb (or similar) downloads really - the many Linux distros don't have a single packaging mechanism, so why pretend they do, or that your app's not going to work on the ones you don't provide?
Just say it's built for Linux, perhaps here's a binary, here's the source if available, this is the preferred name, go and check your package manager.
On other platforms (Windows, macOS, Android, iOS) it’s fairly common to distribute GUI apps as a single binary so you don’t need an army of package maintainers. Perks of having many years of ABI stability.