SD JB or Custom in the bridge, Jazz or '59 in the neck!
JB's a GREAT in mahogany, the Custom similar but a little more high end; Jazz will give you sweeter tones in the neck, '59 more "PAF on steroids"
I haven't heard Within Temptation before... doesn't Lacuna Coil use EMG's? Maybe not, dunno for sure.
The SD site has really good sound clips of each pickup, as long as you keep in mind all the 'dirty' clips are done on a Les Paul, and the cleans on an alder Strat (IIRC). Since the S is mahogany, you should get a good idea how it will sound.