It would appear Engadget has the camera comparisons done for us, in a rather amusingly basic way.
Camera showdown: iPhone 4S vs. iPhone 4, Galaxy S II, Nokia N8 and Amaze 4G (video) -- Engadget
So much for the Nokia N8 having the best camera... That thing looks worse than the iPhone 4 camera.
I saw so many smashed iP4's at my school, the results of this doesn't surprise me.
Simple solution - Don't drop your $600 phone.