Yeah I agree that for power users who use OS X a lot this is not really an issue for long, but it is an annoyance and an unnecessary one at that.
For more typical users it's a bigger problem I think, because they never learn to organize their files. I've seen the results of this with users having a Documents folder containing just a huge list of files with no organization whatsoever - just grouping some related files to send to someone else was a big chore. Theoretically, tagging is superior to a folder hierarchy, but most people just don't "get it" with tagging and never will. Tagging is not even very good for power users, because they will often use software that doesn't see the tags (cross platform editors/IDEs).
I don't disagree that Apple has done a good and thorough job with their keyboard shortcuts. I never felt motivated to learn these myself though because I spend a lot of times on various other platforms, where that muscle memory would be actually detrimental. This is as opposed to e.g. IDE/emacs/vi muscle memory which caries over pretty well across platforms.
But I just think Apple has taken a big step backwards by hiding home in favor of "All My Files". If you have a couple of repos under your home, or anything else with a lot of files that get updated from time to time, then "All My Files!" becomes pretty useless. I think they've pushed too far towards the tablet mentality and that it doesn't suit desktops and laptops very well for the way they are actually used.
They even removed the little dropdown widget that used to show the folder hierarchy (looking for that thing is what wasted my time and annoyed me before finding home under "go" menu). And the status bar at the bottom that shows the used/free space on the machine is also gone (you can turn it back on under the view menu but why make busy people go fumbling around to find these basic things?). Ask most Mac users now how much space they have left on their drive, and watch them fumble around for several minutes...
These things are all so easy to fix!