While monochrome cameras are ideal for narrowband imaging, color DSLR cameras can also gain from these filters—particularly H-alpha.
DSLR sensors often have a more sensitive red channel, so using an H-alpha filter can dramatically improve your nebula shots, even from light-polluted locations. It helps isolate the hydrogen emission that many nebulae shine with.
Keep in mind that exposure times may be longer, and post-processing might differ, but narrowband filters open new creative doors for DSLR astrophotographers.