On the other end of the spectrum, I've been impressed by Netflix search. I would search a name and they do not have that movie, but would suggest a mix of similar movies, movies with the same actors or director. It's pretty clever, I just wish they were more explicit about it, as in showing the reasoning behind choosing a result.
On the other end of the spectrum, try Digikey:
https://www.digikey.com/en/products/filter/embedded/microcon...
or try McMaster Carr:
https://www.mcmaster.com/products/screws/socket-head-screws~...
Functional, well-tagged, data-driven parametric search. Rockauto.com sells auto parts, which requires a whole different type of search, but they deliver a pretty impressive product as well.
I suspect that much of this discrepancy is because there's enough of a chance that someone grocery shopping and looking for lentils will think "Oh, I need pancake mix too" and click on the ad. Meanwhile, someone looking for a specific grade of M8x25 socket-head cap screws or a low-power Cortex-M0 microcontroller with a particular set of peripherals is unlikely to abandon their work to add a hose clamp or electrolytic capacitor to their cart instead.
Market forces seem incapable of delivering a product with a better user experience if that hurts the bottom line even a little bit, they're doing gradient descent to local minima and powerless to say "no" to finance and climb out of the awful product that results.