Ok... I am coming from a N900 with the 5MP + Carl Ziess optics. My 1st phone with a real camera...
Now N8 aside.. the E7 outside of Macro does really really well. I am a photography nut and have a Canon DSLR. I do lots of projects with HD video & have a couple camaers for the job (a gopro HD that also has a fixed focus)
*The Dual LED Flash on the E7 is fantastic. Last night out of a pub, I used it to take pics. Now on my N900 in a low light bar setting the pics would be a big grainy, but the E7 Flash is so bright, no grainy images here, and the Full Focus does a good job, as with my N900 the autofocus would often be blurry in low light. The E7 is crisp bright and non blurry. I even took a pic in a completely dark room tonight sitting on my couch & it lit the entire room up & was pretty damn clear.
*Out door shots are perfect every time, the color is amazing & its just crystal clear all around. I had a cookout today with some folks I go riding with, I used the E7 to take all the photos. I have a link here.
The autofocus camera makes using barcode readers nearly impossible. Some big QRcodes work, but regular barcodes don't. Indoor pictures tend to come out 'foggy', other than that, it seems ok. The speed is much better than in N97.