Apple and Google failed to make push notifications usable for the past decade. Most important notifications drown in a sea of absolutely irrelevant nonsense. It's a very primitive mechanism where many apps compete for very little screen real estate. Beyond "something happened!" there isn't a whole lot of information in most push notifications. They are mostly not very actionable and very vague about what actually happened. And "something happened!" just isn't very useful information to me. This has de-valued the whole notion of having notifications. Whenever something interesting actually does flash by, I often miss it or can't find it back.

The push notification UX is just beyond terrible and it just got worse over time as app developers tried abusing their super power of being able to interrupt the user at will and Apple and Google tried to get on top of that. The net result is something that's very mediocre for the handful of valid uses I have left for notifications. My list is similar to yours. Things like bank approvals, 2FA stuff, etc. are useful mainly as deeplinks into apps. But other than that, it's just not worth dropping whatever I'm doing and staring at my phone.

The most used apps on my Android phone (older Google pixel model) are Firefox and gmail and just a handful of other things. As a notification channel, my email inbox is actually far more useful than mobile push notifications. They are more actionable and informative. And I can individually unsubscribe them or filter them out and easily find them back. Most apps can do both and that makes the push notifications inferior and redundant.