Hardly. The appreciable noise differnece between CCD and CMOS is next to nothing. New sensors are CMOS as they are cheaper to produce. Newer cameras are better researched and perform better, but ultimately while these facts are correlated they have little in common.
That f/2.8 on a point and shoot is nothing fancy, nor anything to get excited about. The small sensors will still produce crap depth of field, and it says nothing about the quality of the glass. Heck given the absense of a lens mount and a mirror they could make a lens with nearly any aperture.
I had a lot of admiration for the Sigma DP1 / DP2 given it's use of a Foveron sensor, rather than a grey sensor with a color beyer filter on it. However from what I have read the performance of colour reproduction and noise was disapointing given its price and technology.
From the looks of the Lumix LX3 I'd say it would be a good option. The idea of less megapixel + higher performance is a good one, but I haven't seen any examples of what it can do so I won't be bold enough to recommend it.