I feel your pain. I spent the last two years hoping for such a solution, and the bottom line is that the solution only exists by pouring over the documentation on the ADLnet.org site. Here's the nutshell, but if you do a project for the navy with only this information, you will run into trouble. The best I can do for you is point you to ADLs "SCORM 2004 Conformance Requirements" pdf file and offer my consulting services I lived on the ADL product downloads page while I was learning to develop for the SCORM.
*this only applies to the minimum requirements of the SCO, it doesn't address conformance requirements of the Content Package, Manifest or Metadata. There may be tools out there that can help you build these items, but I haven't looked for any SCORM2004 metadata generators. You can get "ManifestMaker" from the learning section of the Dreamweaver Exchange on Macromedia.com, which creates minimal SCORM 1.2 manifest files and grabs the XSD control files from the web, then use the ADL XML Transformer and the XSLT documents to convert it to a SCORM 2004 manifest.
Here are the XML tools from ADLnet.org:
ADL XML Transformer v 1.1
SCORM1.2 - 2004 Metadata XSLT v 1.1
SCORM1.2 - 2004 Manifest XSLT v 1.1
There is a new L5 SCORM Producer MXP on the Dreamweaver Exchange, but it is only for Dreamweaver 8, and it doesn't say what version(s) of SCORM it packages for. I'm still on MX2004, so I can't tell you anything about it. If anyone know anything about the new L5 SCORM Producer, let us know which versions it supports!
To answer your first question, no, Moodle won't help you in this endeavor. Moodle is not SCORM2004 conformant yet, and it seems to be unpredictable at times with SCORM courseware. If I were you I would download the ADL Test Suite and launch your courseware through it to test and to see if it meets minimum SCORM2004 requirements.
I hope this helps!
eLearning System Coordinator
Graduate Medical Education
Doctors Hospital, OhioHealth