All things being equal, the C2D is the way to go. However, D-series are much cheaper, and still have a lot of beneficial uses. If you need every drop of performance from a CPU, get a C2D; if you want good performance and save a bit of $, go D900-series.
<---Loves Big D.