I used to really miss the ability in Windows to copy a folder location as text and paste it into another dialog box to go right there.
I just discovered that the Mac allows you to drag any file/folder right into the dialog box. So Cool, you can do it almost anywhere.
When doing an import into photos, you can click on Import and then drag the folder from finder right into the dialog box.
The other thing that I missed was the ability to do a . and see everything in a folder, including sub-folders. I just discovered that you can be in Finde, column view, select all of the sub-folders and hit the right arrow to see all of the files.