Most of the time when someone on HN complains about Finder, it's not a Finder problem. It's that the user doesn't know how to do what they want, and other people respond with the answer.
Finder has its problems. But the overarching problem is that Apple has done a poor job of discoverability and letting people know how to do things.
It's counterintuitive, because in most of Apple's macOS programs there are multiple ways to do the same thing.
For example, there are close to a dozen ways to eject/unmount a disk/volume, but I still run into people who say they can't figure out how to do it.
I think the problem is that Finder searches too much stuff by default. The same problem is true of modern windows search, iOS search, and Android.
First thing I do on all of them is have it only search local stuff. If I want to do a damn web search I'll open my browser of choice and use Kagi. On iOS I restrict it even further to only show local apps and settings. Massively improves the speed, latency, etc etc.
You're describing Spotlight. Finder is the file manager.