Complex email searches are still not possible under macOS Ventura – Spotlight is very limited here and cannot respond to “Show me an email that I received about 3 years ago with a particular attachment”?
Using an email plugin this is however possible.

Houdah Spot (38€) may be life saving here, look for the free trial.