If you mean the 60 cycle hum the output of the pickup won't effect it that much. I have a Stockholm P-90 in my SG Junior.
Now that has had noise issues due to the amp I run it into, i.e. the lead channel of a Peavey 6534+
How I tamed it:
1. Made sure the pickup mount is solid. If the mount is something other than your conventional screwed in P-90 mount or your regular humbucker pickup ring (for humbucker sized) you might run into problems. Also not a bad idea to put foam under the pickup
2. Shielded the pickup and control cavities thoroughly, with no breaks in the shield and an earth wire from the shield to ground. You can either use foil or good quality conductive paint.
This way you have done everything you can to avoid microphonics and 60 cycle hum.
A Boss NS-2 before the amp can also help. I haven't noticed the difference using that recently though.
Don't stand too close to your amp. If you are forced to stand too close often changing the angle of your body to the amp can help.
The most aggressive sounding BKP would be a dogear mounted ceramic Pig 90 in an SG Junior.
Second most aggressive would be an A-Bomb in an SG
Third would be a tie between Painkiller and a C-Pig in an SG
The A-Pig also sounds very aggressive in an SG. Here's mine through a teal stripe Peavey Bandit:
https://www.youtube.com/watch?v=7rSkGpAH3F0SGs just have a very pronounced mid-range focus that makes everything sound really aggressive. I'm not sure which of your guitars might be in the same ballpark. If your Eclipse is one of the thinner ones maybe that.