There are very few things I want to be notified of. Mainly I want to be notified when a person has directly interacted with me or with something I've said. I setup an instagram account forever ago and tried to set it up so I only got those types of notifications, but it would give me a notification to essentially just open the app. I couldn't turn that off, so I just disabled notifications entirely. Now I don't even open the app anymore.
I'm part of a team that uses basecamp to communicate, and I constantly have to unsubscribe from new threads where all of the replies are "ok" or thumbs up emoji or whatever. It's annoying, but nowhere near as bad as the "band" app we used before that. That app had the worst notification experience I've ever had. It would give you notifications for all kinds of things that were completely irrelevant to anything. It's the only app I've bothered to review.