How do I automatically open a subfolder on a SD card when mounted?
With automator you can do this. It'll open a Finder window with the specified folder selected :


You could also make an alias of the folder, and when you plug the SD card in you just need to open the alias and it'll bring you to the desired location. Right click on the original folder and Select Make Alias and put the alias somewhere easily accessible.