Although I've not driven one, the newer Duster is apparently based on the Nissan B0 (MK III Renault Clio, Modus, and Nissan Cube) and handles approximately the same. Those cars I have driven.
Available with a choice of 1.6 petrol or 1.5 DcI engines (in varying states of tune) the options of 4WD and auto transmission, they're just as good as the opposition!
True, it won't break any speed records, although it's agile enough, but personally, I can't see 4WD being much use to me, unless I intend to drive in snow, slush or mud for a good part of the year! You must decide that though! :-)
I think of Dacia to Renault as Skoda to Volkswagen. I'd rather have a Skoda than a VW!
My preference would be the 105 ps turbo oil-burner, as not only is it economical, it can scurry along too! The others aren't exactly sloches, but they'd burn more fuel to get to the same speeds.
You couls also compare the Ford Kuga, Toyota Rav4, and the Nissan Juke, but the Ford seems kind of lumpy and staid, and the Nissan looks horrible! I'm just not sure about the Toyota, as I really don't know enough about it.
If you want a small 4x4, you could also have a look at the Skoda Fabia Scout Estate.