I’m down on DV for two very good reasons. Practical experience shows me that graphics, particularly text goes pixelated compared to ProRes or uncompressed timelines.
Secondly in PAL (which is where I do nearly all my work) it is the only codec with lower field dominance which is a total pain.
All that said, if you shoot DV, capture via firewire and edit in that codec, it looks OK until you want to grade and add titles. At that point move to a ProRes or 10 bit uncompressed timeline. I recommend ProRes over 8 bit uncompressed as I can see the advantage in the extra grey scale resolution when grading.