iOS 15 added something like what you are describing called Scheduled Summary. Notifications are snoozed and delivered at set times throughout the day (twice per day is the default). I believe there is also an API for developers of messaging apps to allow notification privilege escalation.