This is the equipment I use to take all of my pictures on this blog: A Canon 60D with 24-70mm 2.8f L lens. Of course I have other lenses too, but out of those I have I think this one fits best for taking the pics for this blog.
I recently got me this great film scanner you can see on the right. Together with a Kodak IT-8 calibration target and SilverFast Ai Studio 8, this is the perfect combination. I use this, to get high res scans from all my 35 mm slides.