And it sounds like a one trick pony isn't at all what you're after. If you want something that cleans up well and is also very heavy perhaps a Holy Diver might be the answer. Having said that, if you like a really Metal sound then I think you might prefer something with a ceramic magnet to cut through the mahogany. The MM really is the obvious choice but if it's not what you're after then we need something else. I'd have said CWP in the past but when I got mine Tim warned me off putting one into a mahogany guitar and ditto with the PK. If you don't like the MM then, like me, that leaves you with a Cold Sweat. It does clean up well and has alot more character to the sound than a MM. It always seems like a much fatter and richer tone to me and if you had a CS in the neck you'd have everything.
To sum up, Holy Diver for the bridge if you want awesome cleans and a Cold Sweat if you want a more vintage Metal sound. I think you'd probably prefer both to the MM but as your requirements sound so similar to mine and I am VERY biased, I'll go for a Cold Sweat :D