I can say that I love P90s in midrange heavy guitars like LPs. To me they beat out a lot of humbuckers there cause the P90 character adds more high and low end while opening up the midrange. It just works extremly well with the warm, middy mahahony character of most LPs. Plus the bottom end is much more defined and natural compared to HBs imho, which is another great factor on neck pickups, and also expecially with that scale length.
You will not get a full single coil style tone as a P90 is fatter, warmer, more powerful, and has a certain roar. To me the "best of both worlds" is what drives it home.