Do you find any solution? Same for me
I have 16 GB of memory and 2 TB of storage on my MacBook Pro (15-inch, 2016). I reformatted my SSD, performed a clean installation from a USB thumb drive, restored all my data from a new Carbon Copy Cloner backup, rebuilt every mailbox in Mail, and checked the settings of each Smart Mailbox. Nevertheless, smart mailboxes will not update their content. If you click on one, it will display the content, but if you click on the next one, it will still display the other content without refreshing. In other words, Today's and Yesterday's email is the same, or This Week's and Last Week's email are all the same.
In answer to your question, I've
downloaded and installed Spark, which I've been using on my iPhone and iPad for the past year. It works perfectly. I'm not going to bother with Apple Mail anymore. It's becoming useless, just like Apple Music (and iTunes before it), which brings a Mac to a standstill (just short of a freeze) for an entire day while opening. Spark already had a superior interface to Mail on the iPhone and iPad, so I might as well abandon Apple Mail on my MacBook Pro as well.
Besides, for at least a year on all three devices, Apple Mail has persistently had ghost Unread messages counted in the Badge as well as in the message count of smart folders, so that's already annoying enough. Try Spark and forget Apple's Mail. My frustration with the iTunes and Apple Music application bringing the computer to a near standstill for hours prompted me to switch from an Apple Music subscription to a Spotify subscription. These poorly performing native Apple applications remind me of when Microsoft Word was becoming unwieldy a few decades ago on the Mac. It's not a good sign.