https://github.com/thunderbird/developer-docs/blob/master/th... and https://blog.thunderbird.net/2023/02/the-future-of-thunderbi...
I've never had problems with Thunderbird on that front, but then again, I've never had email accounts with 100k emails archived.
If you want mail to just work and updates going smoothly it's the solution.