Well, of the three pickup sets mentioned each was designed to give a certain sound.
Cold Sweat: early '80s John Sykes sound
Rebel Yell: signature Steve Stevens (Billy Idol) pickups
Emerald: Brian Robertson's sound on 'Live and Dangerous'
Of these the most 'seventies' and PAF sounding is obviously the last of the three. All are great though. I tend to feel though that the RY and CS neck pickups suit a different kind of lead player from the EM neck. I really went through this with my friend before setting on the Emeralds, based on his style, which includes a lot of bends and vibrato type blues playing, which I think the Emerald neck is especially suited to, whereas the CS and RY are more clearly '80s 'shred' pickups. It really depends on what you want.
I have the Cold Sweat set in my SG and love it. I'm also very taken with the Rebel Yell clips.
All three are bright and will work well in (1) Les Pauls & (2) mahogany guitars that have had bright pickups (e.g., EMGs), and all three will give a Gibson character, although different eras.