in my LP classic antique, all mahogany with tonal chambers, the mules are definitely brighter than i thought from every description... this can depend mostly from the tonal chambers, that brighten the tone giving it that snapping attack typical of hollow-bodies. AND from the fact that actually my bridge mule has got an A5 instead of the traditional A4 magnet.
anyway if you're looking for an expressive and dynamic pickup that's great for rock, hard rock and blues, you can't go wrong with the mules.
if you feel that your LP is acoustically bright and want to darken things a bit then black dog in the bridge. no direct experience, but it's basically an overwound and darker mule.
i'd stick with the neck mule, anyway. i can't imagine how anyone could dislike it! ;)
i can't comment Tim's suggestion because i've never focused my attention on riff raffs, so i don't know much about them.