It's so bad for me that I often drop down into Terminal, find there (with 'find') and then use 'open'. I'm very used to doing this.

I've just assumed that Finder is fine for non-technical user so no one complains. But fair point. It can be fixed.