I have no experience with other learning management systems (LMS), but I have found moodle to be very easy to both navigate and add content. It seems flexible in course structure and there does not seem to be any glaring deficiencies.
As far as online learning is concerned, moodle does not get in the way at all. This will allow instructors to be free to design and implement courses and not be bogged down with LMS issues. I have found moodle be very helpful in organizing the on-campus classes I have attended thus far. All the information for the course is in one area and I don't waste any time looking for specific information.
We are currently evaluating LMS's for our seminary and we are trying moodle for the upcoming semester. We will use both a blended and fully online structure for our classes. This has been a real help for us and will enable us to extend our 'classroom' across many miles.
As far as which type of media works best with moodle, I can not say that any one type is better than another. Again, moodle seems to work well with just about any format we have tried thus far. This is great because instructors can use whatever technology they believe will make the course most effective without any concerns with moodle.
I am looking forward to the potential that using moodle affords our seminary. The final determining factor, of course, will be the students evaluation. But once again, I believe that the evaluation will be centered around content and not delivery (moodle).