I thought I understood resolution, but suddenly someone is saying I'm wrong. Fair enough, but let's see what others think.
Is there such a thing as a "high resolution" camera, or does the term only apply to print images? Would a 4 megapixel camera be considered to have the same resolution as a 16 megapixel camera (extreme limits)? My contention is that the 16 megapixel camera is higher resolution because, for the same image size, there are more pixels per inch, or DPI if you prefer for prints, than a camera that has a lower megapixel rating, and therefore its resolution is greater.
What has been said is that if an image is print ready, it is considered high resolution. I am disagreeing with this statement, but if I'm wrong, I'm willing to learn. This statement came up in reply to a question of what is considered a high resolution image? I'd still like an answer to that question. And if there is a difference in camera resolution, what would be considered the threshold between normal and high resolution ... 8 mp, 10 mp, 12 mp or

This can lead to another tricky question. If a camera is of sufficient resolution, is it possible for it to show too much detail, enough that very fine detail, particularly in the background but elsewhere as well, could be mistaken for artifacts or possibly noise, depending on the detail's shape, color and size?