The search bugs in Mail are absolutely real. They might not affect every user but I've had major issues on both macOS and iOS mail, and eventually gave up and switched to Gmail.
Mail search works flawlessly for me with Gmail and Outlook. It takes a sec but the results are always relevant.