Want resolution? Have I got the cameras for you!

http://www.gigapxl.org/ Digital
http://www.cliffordross.com/R1/R1-detail.html Film
http://www.superlarge.com/ Film

On a more serious note, I use extremely upper high end digital cameras for mapping. Camera systems cost a few million bucks. The digital imagery is better than film in terms of geometry. But the digital spectral response is still nowhere near as rich as film. There is just no way that 3 discrete bands are capable of superceding the tremendously complex and rich spectral response of film. But what digital lacks in response it sure gives back in consistency.

I figure that we're at least 2 generations of advancement before digital color is competitive with film color. Maybe more in the NIR wavelengths.

FYI.