Since most of us have found ourselves dealing with a lot of photos, both digital and physical, Macworld has put together a really good article, The new digital darkroom, that briefly covers Adobe Lightroom, and Apple iPhoto and Aperture.
It delves into organizing and managing your photos, as well as publishing (slide shows, printing, web pages, etc.). It also looks at where Photoshop fits into the scheme of things.