There are a lot of variables, what is the source footage, what do you need to deliver etc., that help you decide which codec to use.
Most of the codecs you mentioned are generally developed by camera manufacturers, its the standard they use to put video to tape. The NLEs conformed to the same standard to be able to edit it. So if your shooting DVCPro50 use the corresponding codec.
However recently there have been codecs developed that are more uniquely suited for the post-production process, Sheer Video, Cineform, Apple Intermediate Codec (AIC) and more recently the Apple ProRes codec. These codecs do not have the same bandwidth constraints the camera manufacturers have when recording video onto tape, all of these newer codecs enable you to to encode at higher bit rates and color fidelity that is better suited to editing.
Also using a common post-production codec allows you to share your content much more efficiently, which is kind of the point of Editshare.