Maybe I'm not a "power user," but I'm using the Finder for graphical file management roughly every day and it's just not a super big issue for me.
These "Macs aren't for power users" threads always kind of fascinate me, because it's so clear how differently people define "power user," and at times it feels like a lot of people define it as "this system has defaults that I don't like" or, even more often around here, "If I ever feel like I have to touch my mouse the system is crap." Whereas for me, I want a launcher/workflow runner like Alfred, which very often is my "command line" for a lot of functionality. I can assign a keyboard shortcut to anything in any menu in any application at the system level. I can wrap Unix scripts in Automator actions and put them in the Service context menu, so I can highlight text in any application and run it through a filter with a single click. I drag the proxy document icon in the title bar of windows to perform actions on that file all the time. To me, these are totally "power user" things, while I've never once thought "man, if only I had a mouse-free tiling 'window' manager that just split the screen in multiple sections with no overlapping windows I would be so much more productive."
Also, I'm typing this on a 2020 Macbook Air and it has a terrific keyboard. With the release of this 13" MacBook Pro, AFAIK this eliminates the butterfly keyswitch from their lineup.