I used to do this but it ended up in me missing notifications I actually cared about
The best solution is as someone else mentioned, just mute apps that send obnoxious notifications when you see them
Different notification sounds for different kinds of notifications has been big as well, one for messages, a different one for twitch streams, and another for everything else that normally gets ignored