I find most of macOS reasonably well designed (at least compared to the competition), but Finder is truly awful. I highly recommend Forklift as Finder replacement.
Thanks for the Forklift recommendation. I've used Path Finder off and on for years, and it has some advantages over regular finder. But it doesn't seem to have enough differences, and their distinguishing features are not readily apparent. Path Finder also has features like upload to S3, but they put that under the menu (Commands -> upload to ).