None of the current cameras are awful. I use the Droid 1 as a reference (it had a fantastic camera for it's time)...all of the cameras I have seen are as good or better than the Droid1.
For me the main thing I wanted was good low light quality. That was something I really hated about the Droid 1...it took great pictures, but only in daylight conditions. In lower light the quality dropped real quick.