I have a shit-brick Fender Contemporary Stratocaster HSS from the 80's that's made out of basswood, and the Dimarzio Super Distortion was easily the best sounding pickup in it. Love the feel of the guitar and the neck, but the wood sounds like shit. The SD has tons of bass, girth, and enough highs to make notes jump out of a dull guitar.
Definitely check the volume pot too and make sure it's at least 500k.