Turn off sound notifications globally on MacOS

Is there any way we can add a global setting for sound notifications on MacOS, or an option to have the default for newly installed apps to have sound notifications off by default?

Currently, sound notifications for apps need to be turned off one by one, which can be time intensive if lots of apps are installed.