Noise-cancelling microphones are most commonly used in the recording of vocals, loud instruments (such as drums or amplified guitars), and speeches.
A noise-canceling microphone is only important if they are capable of reducing the levels of ambient background noise without significant coloration compared to a non-active model; this way the talent won't be drowned out by sound coming from other sources.