Hi, you don't really need to worry about this at all.
The only folders you can't see, compared to USB like before, are the hidden folders which are usually just folders for application data.
It does show up as a device rather than a drive letter, but drag and drop works exactly the same, no need for extra sync software. I won't bother taking a screenshot because it looks exactly
the same as transferring files to an android device which uses the old USB method.
To answer your question "How hard is it to get my pictures, music, Docs, etc actually ON to the device", the answer is - it isn't hard at all, and is effectively exactly the same as the old method (better in my opinion as you don't need to mount/unmount). The only way in which you could have problems is if you use a Mac or Linux and then you need extra software, as you're using Win7 you won't have any problems.
Hope this helps
edit - actually I had time to kill so here are some pictures