I’ve never found Thunderbird search bad compared to alternatives, as long as I’m not looking to find content inside attachments. Really fast and responsive and being a desktop client without paginated results makes moving and deleting in bulk so much easier. Would love it to be as powerful as Voidtools Everything to get a bit more granular sometimes but otherwise pretty happy with it.
For something in-between, there’s https://winstall.app/