Apple now has now partially implemented the feature I asked for in iOS 15, Sender can now determine whether the receiver who has 'Do not Disturb' should be notified after sending the message. It's part of their 'Focus' suite - https://youtu.be/A2T-52AuMvo?t=235 .

You might be interested @reed_wright .