Does the myPages service allow me to create a website in Dreamweaver or some other tool and then upload the set of files?

No,  the OpenScholar framework is designed to allow users to create websites without having to do HTML or other coding.  You use a set of tools and apps to enter content within the myPages service itself.  You cannot compose a site elsewhere and then upload it for hosting.  We are looking a options to allow linking to individual HTML files so that is someone has some raw data or information to share in HTML format, you can do that.  Currently, you cannot even upload an HTML file within the tool.  Even if we get that working, it still will be limited to individual files like you might like to an individual PDF or Word document file.