The goal was to make it so sites that already support standards based Web Push work out of the box.

We'd expect most sites that support standalone mode when added to the Home Screen and support Web Push to Just Work™

3 real world examples are lichess.org for Chess fans, elk.zone for Mastodon fans, and twitter.com for those that still actively use Twitter.