Here is my take that is revalent to Italy. I have been to Rome probably 5 times in the last year. All for work, but I do get a day or two here and there for personal time. Anyway, the camera I was taking was a Nikon Coolpix 8700. I like the prosumer digital just due to its size and capabilities. Anyway first trip I did not take a seperate flash. Visited St Peters, and tried to take pictures. No way. Too dark. At least for the quality I wanted. So, next trip I brought along a SB-80DX. A pretty strong flash. I still had issues with pictures without cranking up the ISO. And of course then comes the noise. Had the same problem at the Pantheon as well. All of the big open interior buildings are pretty dim on the inside. And when the ceilings are over 60' - 100' tall. I just don't think a P&S is cut out for it. Of course I wanted pics of the fresco's in the ceiling and coupola's.
So, I just ordered a D40x for travels now. I am hoping its bigger sensor (over p&s) and decent lens will give a little more low light ability over the 8700. I specificaly bought it 1 becuase it was cheap, and 2, it's really small. I don't want to take a system bag with me or a larger DSLR just do to the fact I have way too much to carry as it is (work stuff, clothes, computer). So I am going to give the D40x a try. See how that works out. I think I am going to try an all in one lens (always stayed away due to aperature size). But taking just one is my goal. Of course that may put me right back in the same spot as above with needing high iso for large internal pictures.