What guitar do you plan on placing it into?
I just got one put into my RG1570 (made of basswood, with a
Rosewood fretboard).
My RG is very bright, due to the wood it is made of, so that is a consideration you should take into account. The HFM is a very bright, spanky sounding pickup even though it is a neck pickup. At least for me, to get that warm fat tone usually associated with neck pickups I have to roll down the tone knob a bit.
It is definitley a different sound than I am accustomed to in a neck pickup, and that is why I love it so much. For distorted leads it is amazing, and for bright cleans it is amazing. And if you add a coil tap... well, the versatility is unlimited. But, if you need that fat Jazz tone, you'll have to EQ at the amp, or just roll down the tone knob a bit.
It is not a very high
output pickup, and actually has a single coil-like sound even though it is a humbucker.
I highly recommend it.
I am using the HFH in conjunction with the Tonezone in the bridge. Not sure about the Super Distortion, but the Tonezone is just ridiculous. Once got it back with the new pups I played my guitar for 4 hours straight, broke a string, restrung it, played some more until my wife finally yelled at me to come to bed.

Tonezone + HFM is a GREAT combo.
Ryan