Many thanks for this very useful answer. I like your lucidity. I'd like to ask you some more questions:
Using film cameras, is there ever a problem with fuzziness, vagueness, etc., in a picture when it is enlarged?
Of course. Film cameras dealt with poor focus, inadequate depth of field and motion blur just like digital cameras. These problems result mostly from the way the camera is used, not what kind of camera it is.
I like to look at my pictures on a large computer screen: would I run into a problem looking at a photo taken with a 24MP camera?
You would likely have no problem with a 5mp camera. Remember that the greater the pixel density, the smaller the pixels. We are past the point where adding more pixels accomplishes anything meaningful. The trick now is to make the sensor larger so that we can have more pixels and larger pixels.
Is there some quality in a Leica camera (e.g. sensor, lens etc.) that makes it special?
No. I can't imagine that Leica is in the semiconductor business. Likely hey buy sensors from a semiconductor manufacturer.
Another reason why I attracted to a Leica is because they are built with a lot of metal that will help it withstand bumps and bruises as I travel a lot.
Metal bodied cameras are available from most brands. If you want a Leica, buy a Leica. Just don't get hung up on pixel density. It stopped mattering quite a while ago.