Hi and welcome.
A P90 certainly can be agressive and raw, yet also sing wonderfully when you turn down the guitars controlls. The also are very good with string separation and clarity, so you should not worry there. Since they are at their core single coils they have a great defition, especially on the low strings. The Nantucket and MQ are so close to each other that they are basically the same thing. Just used to be that the NT was P90 format only and the MQ humbucker sized. They also should deliver the exact range you want. Classic clean sounds to agressive distortion sounds like Muse or so are no issue (they use them a lot). Also P90s loooove fuzz and handle it much better than HBs.