'horrid vocal effect'? What do you mean by this lol.
The pitch-shifting effect or 'auto-tune' - you can't hear it? It's to make people who can't sing sound kind of like they can sing. The only vocal effect that I hate more is the warbly vocoder robot vocal thing, which only Roger Troutman ever managed to make sound even remotely cool. There's a good reason why people seem to prefer the instrumental version of the Periphery album ...
Anyway, you probably hate the vocals of the punk, thrash, and grindcore stuff I listen to! One of my all-time favourite vocalists is Dean Jones from Extreme Noise Terror and Raw Noise, who basically bellows! It's an honest bellow though, and he always combines it with cliched punk fist-pumping, so it fits. ;)
I think there's a good chance you will be happy with either Nailbomb option. The alnico one is more middy, but a Les Paul has enough mahogany to tame that a bit, and it might give you that hardcore edge you seem to be looking for. The A-Bomb is the most hardcore sounding pickup in the BKP range I've heard, especially in an SG, and it retains something of that in a Les Paul but more toned-down and versatile. Do you like Sepultura at all? The A-Bomb has that kind of character, more or less pronounced depending on what you put it in.
There is a return policy with BKPs and if you live in the UK that is a realistic option.