Got the guitar back from the tech!
Just turning on the Blackstar HT-40 (with the settings I had). HOLY MOLY! The Super Distortion gave me the real KISS tone, very powerful and cool indeed! Boston, Def Leppard rhythm tone, Judas Priest, etc. I could even nail early EVH tones! The Transition, well.... it was dark, very EMG like, lacked spark, sterile sounding, very bassy, dry... It ain't the best neck pickup I have ever played... A day later (today) I gave it tries thru my Marshall MG15CD and the Blackstar HT-40. The Transition has an amazing singing tone. Sounds more Slash than Slash with just the right push so the creamy sounds get out with punch not stuck. The Transition necks acts like a bridge pickup. It ain't a traditional sounding neck pickup, the leads are better than the ones in the Super D, it cleans up pretty well with the volume knob too, very good tracking too.
I believe this is a quite ''unbalanced'' combination. The Super D sounds amazing, but needs a more vintage pickup in the neck position. The Transition, well... maybe get paired with the Transition bridge? I know the Transition will part from this guitar one day into another, but I will not sell it. It definitely offers something. I'm actually thinking of using Super D for rhythm and riffs, Transition for solos and cleans; but both clean up pretty well.
The Duncan Custom SH-5 is definitely still one of my favorite pickups and the one I believe is closest to the Dimarzio Super Distortion. The SH-5 is darker with more thump in the bass, slightly less mids. The SD offers better cleans, but the SH-5 has better OD leads. Very interesting.
I believe the case at least on this guitar will continue...
The Transition would go to another guitar in the future. Just need something that's really a neck pickup, not a neck pickup pretending to be a bridge pickup.