I handed one of my SD1000's over to my 2 yr-old grand daughter when she was here the other weekend. I think she got the concept of it taking pictures but her manual dexterity isn't quite there yet for holding the camera, small as it is. I'm sure it won't be long before she'll want to try it again seeing as she's a very smart 2 yr-old.
I wouldn't mind trying out a Leica. I tend to like rangefinder lenses quite a bit due to their different rendering qualities. Unfortunately the price of entry for a body is still quite high for me! Maybe down the road, I'll get a used A7II with a thin sensor stack mod to fully enjoy the lenses!