My rule of thumb for notifications:
– Will I need to act on it?
– How time-sensitive is it?
– How important?
– Is it actually for me, or is it an ad for the app service?
I turn off what I don’t need, turn off sound on the less urgent ones, and customize sounds for the most important ones.
So I hear when a text or IM comes in, but not email or social media. When I pick up my phone I see emails, mentions & replies, but not favorites or boosts, etc.
It helps me a lot with alert overload. YMMV.