Something to keep in mind that with virtually all sensor chips in use today, there is a Bayer Array to produce color information. This method quite explicitly trades resolution for color information.
The result is that when you pixel-peep, you ALWAYS have more pixels lying around than there is resolution in the final picture. It will ALWAYS "look blurry" if you dig in far enough. The Bayer Array trades roughly half of your sensor's resolution for color information, so your 24 megapixel sensor produces, roughly, 12 megapixels of color picture. This is invariably delivered to you in the form of a 24 megapixel file.
This is a good thing, for the camera makers, because it keeps the gear-heads strapped to the wheel. They'll continually pixel-peep, buy better glass, buy a new body, buy, buy, buy, chasing a chimera that is mathematically impossible. And thank goodness, those guys fund the R&D that builds the gear I want!
The exceptions are b&w sensors and the Foveon design from Sigma, as far as I know, and those are pretty thin on the ground.