Oh wow THANK YOU @Claire and @noellabo for the v3.3.0 feature "Add unread notification markers in web UI".

For those who can't parse the understatement, one thing this does is: if Mastodon is not open in your desktop browser and you get a notification from someone, when you open Mastodon there will be an accurate notification count.