I agree that preview is nice, as is Spotlight. But for me, OSX is getting too locked down at this point as a "power user". The sandbox makes apps take obscenely long to open like as if I've been teleported to the 90s with spinning disk laptop hard drives. A bunch of useful preview extensions all broke with Catalina's latest efforts to lock things down more and more. I hate how many hoops you are forced to jump through to get any non appstore app to get installed.
I thought OSX + MBP would be a solid and stable experience but I've been plagued by a well known kernel panic based error very frequently when I plug into a dock, resulting in hard reboots.
I'm definitely going to switch back to Windows with my next laptop. I'm sure there will be things I will miss, but OSX hasn't lived up to my expectations. I do most of my work on an Ubuntu box via VNC/SSH, and the lack of CUDA support makes the MBP kinda useless for prototyping ML/DL stuff as well.
Brother, I feel you. I hate finder so much I operate almost exclusively from the command line in os x.
https://www.lifewire.com/thmb/vSLzUT0-KVRp7uMtbjOa3qsYMmk=/1...
Then I tried macOS 10.4 and found the Finder an absolute joke in comparison and other than QuickLook in 10.5 there haven't been any improvements since. The only things that the Finder has going for it are QuickLook and the columns view, everything else is pretty subpar.
Nowadays I don't do much file management (or so I lie to myself) so my Mac is good enough for that.
Try Forklift, you might like it if you hate Finder.