The Duncan 78 (yes, the VH pick up
) and the 57's will do exactly what you describe. The Phat Cats probably would, too, but with a but more snarl and maybe a bit less oomph.
I was really impressed by the Duncan. There are probably several winders on here that can do something similar.
My only reservation about 57's is, I have a very old one, early 90's. It sounds incredible. I am not sure the newer ones sound as good. However, on the ETSG forum SG Guitar Forum - everythingSG.com
, there are a lot of people that agree that 57 Classics sound great in an SG.