All filters work by eliminating the undesirable wavelengths, and transmitting the ones we want. Astronomical nebula filters of all types, transmit a very tight set of wavelengths. Two things happen here: one, the percentage of light transmitted as a whole is small; two, the wavelengths that are transmitted, our eyes aren't the most sensitive to. When you get down to "ultra high contrast" nebula filters that the NPB is, the transmission is even less.
The only way around this is just by sheer brute aperture, which is the only way to get enough light through that is bright enough for our eyes, particularly with the UHC types.
An NPB filter will work in your 6", but as you infer, the image won't be very bright. For your aperture, an OIII and even a broadband nebula filter would be a better option. An OIII filter is also the best option in light polluted areas.
I have an NPB, an OIII and a broadband filter. The broadband I don't use much, and really only with my smaller scopes. The NPB gets used only at a dark site with my 17.5". The OIII is my most used filter, both at home and out bush.
Fellow IIS member, John Bambury, has written a very good
article on astronomical filters you might like to go over. It discusses not only nebula filters, but also coloured filters and their applications.
I think you would be best served with an OIII filter, rather than an NPB or other type of UHC filter. GSO also makes some decent OIII filters too. My 1.25" OIII is a GSO, and I'm very pleased with it.
Mental.