Put the photos into iPhoto and Aperture will see them as well. Lightroom you may need to point it to the iPhoto Library file.
Movies, I would just drop them into the Movies folder, unless they are iTunes compatible, there is little point putting them into it.
Music, iTunes obviously.