I tested the Nokia N97 Camera for a short span of time when attending the N97 Event in Bangalore.
Here are downsized pics of the 5MP photos taken by the Camera phone .
This pic is the best of the lot
This one was taken against the sun to see how the camera handles details in long shots
Can u See the lady seated on the left and the leaves on the right ?
The camera handles the reflection in the water nicely.
You can also check this post for more camera samples of the N97