Neck humbucker position on 24 fretters and SGs sounds better to me.
P90ish-hot-single, right at the end of the fretboard, sounds good on either 24 or 21/22 to me. I imagine the PRS NarrowField pickups would fit this either/or, but cannot verify, as I haven't got one handy to try on a 24 fretter.
Cooler singles and vintage output mini humbuckers sound better to me on 21/22 fret guitars right at the end of the fretboard.
The big exception is my Tele with the SD Jazz at the neck, but that HB is defaulted to parallel, which really sounds a lot like a wide single coil, so I guess that is really the key to it working there. The hotter the neck pickup, the more likely it needs to be a smidge closer to the bridge, like a 24 fretter's neck pickup, to pick up (heh heh) a bit more high end....