Sigstore in general? A fancy, colorful website that GPG does not have.
I'm guessing the genesis was since Debian already checked package hashes to ensure no download issues, adding a cryptographic signature to the file containing those hashes was an easy, minimal change that would not break existing clients that didn't know to check it.
Off repo is a use case that IMO should be strongly discouraged (as should adding random repos), but to your point, if you have no choice, a per-package sig would be useful.
Because of reproducible builds?
But what kind of magic signature do you want to know that the code you're running matches the source, if the software is closed source and you have no access to the source?
Your requirement makes no sense. Are you a product manager? :D
If your supplier doesn't sign them… take it with them?
That the server cannot provide malicious response X to just the victim, while looking innocent to others. Certificate Transparency forces the signer to publish the fact that they sign something, leading to such attacks being noticeable, in the sense that "there was an extra thing signed and it's not the usual thing".
With TLS, the idea is that big corporations can tail the CT log and make sure there have been no extra certificates created for their domains.
(I can't vouch for whether this work achieves that goal. Something needs to check the inclusion proof in the client, before trusting the data. Auditors need to tail the CT log.)
Debian packages are already gpg signed. Majority (and Debian is working toward the goal of all) packages have reproducible builds. Their CI system even automatically does multiple consecutive builds of packages to automatically detect issues with reproducibility. So, in the majority of cases, you can verify that the binary package you installed matches the source package it is claimed to be build from.
You have to go to extra effort to install an unsigned package / package that fails signature verification with what currently exists. So, you are not going to accidentally install a package that fails signature verification with just the current protections in place.
So, am I missing something? Or, does this new thing add nothing to the protections that are already present by default?