Depending on exactly what you mean by multimedia CD, my suggestions would be multi media builder from www.mediachance.com - there is a bit of a learning curve but its very a very flexible program.
Are you talking about a "business card" type CD with resume' , video, and still photos?
Best program for that is Autoplay Media Studio. I have version 4. Indigo Rose is now up to version 6, but the price is now out of sight. See if you can find the older version.
MultiMedia Builder is fairly easy to learn for simple stuff, and they have some good examples as well as a good manual. Scripting in MMB can get complex, but the manual assumes no programming background; it's entirely possible that you won't need to do any scripting, or if you do, you'll be able to use their script wizard to create what scripting you need.
The downside to most of these autorun CD programs is that they only run on Windows - so if you have a requirement to be able to run on Windows or MAC, then Flash might be a better option.
Autoplay media studio will do what you want. It handles flash and Mpeg 1 very well. See if you can download version 4 somewhere. It is more than adequate and easy to use + plenty of tutorials and forums.