The problem, I've found, is not resolution but color quality. The dynamic range of the chips in these cameras can't reproduce the full depth of color in a complex photograph. In addition, the built-in compression of the images loses a little bit more color detail. If you scan a picture without compression right into Photoshop, you have more of a chance to decide yourself how much quality you'll lose in the process. In addition, standard film cameras have many different lighting and lens options.
Most digital cameras are limited to just a few, so a complex composition is harder to capture.
For news, information and quick photography, I think digital cameras are best. But for catalogs, product shots, even important head shots, a slide or print scanned properly on a good quality scanner will deliver the better image.