Indeed, I tried to learn how to make a Debian package. A proper one that followed the guidelines (even though I wasn't trying to get it into a repo), not just one that's shoddily converted from another format.
The tools are just a bunch of hacks designed for the particular environment and habits of the few people who make Debian packages. They don't even try to document how an outsider would learn to do it.
Not sure why you added systemd to this, though, except to appeal to the old guard of sysadmins who don't like systemd and show up on HN a lot? It seems a completely unrelated conversation.
Which is what things like snaps, appimg, flatpak are trying to do
Linux distributions are also harder to deal with than the Apple Store, an "accomplishment" given how bad that is. Getting a package into them is terrible. They are informal cliques, and that worked back in the 90s but now doesn't scale.
Package management in general is an area ripe for a complete overhaul. Unfortunately that's hard, and it's hard not to fall into the "second system effect" trap and create something even more unwieldy than what you are replacing. Look at systemd.