Kubrick had cameras built specifically for those scenes in Barry Lyndon. Using optics developed by NASA, which he later patented. And the camera body itself was pre-composed from one of the rarest, but highest quality 35mm cameras ever to have been built. I don't remember the name of the cameras, but there were only like 3 of them left in the world when Kubrick lifted two of them for himself from an unsuspecting studio.
At any rate, if you're going to shoot DV, and you know that you'll be in situations with minimal lighting. You'll want to consider these cameras:
Sony DCR-VX2100 or DSR-PD170 (rated at 1 lux, Zeiss optics, and the availability of a PAL model)
Canon XL1s (rated at 2 lux, with a wide range of manual shutter and gain adjustability, and of course, the ability to replace the lens. No other camera in this price range can claim that. PAL model is also available.)
Panasonic AG-DVX100a (rated at 3 lux, 24P,Leica Optics, and tons of other cinegamma settings that enhance low light shooting. PAL model available.)