I am frustrated because it is comparing apples and oranges. Sure - both take photos, however most comparisons made are unfair, biased and just plain wrong. Let me get this out of the way first - any DSLR or modern mirrorless camera will smoke any cellphone camera under all circumstances, ignoring for the moment the photographer and the concept of availability. Once you start arguing that the camera you have with you is better than the one left at home, you are no longer comparing cameras. You are comparing laziness and personal attributes of the photographer. I am not saying it does not contribute to a camera system's success or usefulness, but one cannot use it in image quality comparisons - which is what all these reviews are about. Furthermore, all these reviewers have the tendency to show images at small web resolutions of about 0.3MP. Granted, for exclusive online use that is a fair comparison, but once you use it as background image on your computer or try to print it, the small resolution images are misleading.
So we have established three aspects to describe the relative benefit of one camera system over another:
2. Portability / Availability
3. Photographer skills
Lets briefly finish the discussion of points 2 and 3 above. There is no contest - a mobile phone is more portable and more available than any other kind of camera - it wins hands down, congratulations.
There is no question that a cellphone camera is easier to use than a DSLR or mirrorless camera, hence less photographer skill is required to produce a technically fair photograph. Or stated in other words, a novice photographer will take a better picture with a cellphone camera than with a DSLR or mirrorless camera if he is completely unfamiliar with both cameras. Another win for cellphone cameras.
Now on to the point under discussion - since all these sites show pictures under different scenarios and compare them, they compare a camera that is on hand and one can assume that the photographer is familiar with each of the camera systems.
Without writing one single word more on this topic, I dare you to reproduce the below images with a cellphone camera (without any adapters / lenses / etc. as that renders the comparison unfair - you have then converted the cellphone camera into a hybrid camera which is a different class of camera).