Well, I can only talke by my experience but...
A-NB works amazing great in my Caparison Orbit (Mahogany + Maple neckthru)..
C-NB works insane in my Caparison Angelus Custom (Heavy mahogany body + maple top).
And I'm using a Diezel Herbert and all the guitars down to C and drop A#.
That saying that the NB doesnt work properly with Mahogany,, well, in my case, I think the contrary, they are really great... (In fact, I really hated the PK in my Orbit, and I replaced with a NB, and now is perfect)
Now I'm in a similar situation, deciding new pickups for another V guitar, and I'm between the C-PIG or the C-NB, not 100% yet.-.. :( maybe the C-Pig to try something different