I kinda have the opposite problem. I turn my phone to silent because I'm at a restaurant or cinema or whatever, then 3 or 4 weeks later discover I never remembered to turn it back.
And I'm 100% OK with that, I've gotten good enough at turning the ringer on when I'm expecting a call, and not worrying about "missing calls" from people who aren't in my VIP list or who don't leave voicemail.
The few times I do not notice a notification, I'll pick up up when just keeping an eye on the time.
Not having bings , boops, and rings surround my life has been a huge nicety -- Far more than I'd have expected. Highly recommend if someone wants to be 'notified reliably' but has the modern day sounds also drive them a bit nuts...
First one sets my phone to silent when I arrive at work (500m radius I think). It also sets it back to loud (or whatever the previous state was) automatically when I leave that radius.
Second one sets my phone to loud when my phone connects to my home WiFi. This helps with the problem you describe - but agreed, phone stuck on silent isn't generally an issue (until I miss some courier's phone call and kick myself).
It may be Pixel-exclusive, though I used to use the Google Assistant rules on my old phone and they mostly worked IIRC.