In the end, it turns out for me that the classic explorer Tree View is the most intuitive. I know where things are as a sub-tree system. I get that hard links etc. complicate this and perhaps there are smart folders etc which do not fit this model well but I find I frequently want to “Go Up” in the hierarchy and this requires an uncomfortable shortcut on a Macbook (arrow key) or a menu button rather than a toolbar icon.

But these are complaints. The right answer is to see if I can build a file explorer for MacOS that behaves in the fashion I desire.