If Tim says that middle-output pups (e.g. Rebel Yell, Holy Diver) don't work as well in SGs as lower-output (i.e. SM, Mule) or high output (Warpig), then I'd generally be inclined to believe him unless I was pretty sure that a middle-output pup was really, surely gonna give me the specific tone I wanted.
And, anyway, I'd think an SM or Mule would be fine for playing "Hotel California" :) and probably either would work well for Santana tones in an SG, probably better than a Holy Diver or Rebel Yell (RY, cool pup tho it is, is not what I think most people would recommend for Santana tones).