Camera phones are real good for taking photos that will not need to be enlarged say to 8 x 10. Plus you don’t have to fiddle around with the settings to get an excellent photo.
A typical photo I take with my LG G3 camera is 4160 x 3120 pixels. I reduce the height to 30% to see it all on my 27” pc monitor and it looks very good. Bigger then any photo I would typically print such as a 4 x 6” print. If I look at it full size the graininess shows up.
My Sony NEX-7 with a APS-C sensor on the other hand blows away the cell phone camera with much better detail not only in daytime photos but also indoor photos. Bigger lens and bigger sensor.
The future is already here as another poster mentioned this camera listed below. This is expensive now but as we know the prices only drop in the future. It has a bigger sensor and high quality lens with zoom.
Panasonic Lumix Smart Camera CM1 - many reviews below.
Full 1” sensor (same as the old 35mm film cameras)
https://www.youtube.com/results?search_query=panasonic+lumix+smart+camera+cm1+review
That's not a phone. It's a CAMERA with a phone stuck on it! LOL!