As a general trend in voicing, character and response to playing, quite apart from output, longer winds/hotter pickups tend to do two things; decrease high end (but not low end) and increase compression.
That gives hotter pickups a more percussive low end and thicker sound, while lower output pickups lack 'thunk'; crank the gain on the amp till you get about the same amount of clipping and you'll have a grindier tone without as much guts to it. Its also benficial to have some compression there because of all the palm-muting us metallers do (I refer you again to 'thunk')
Go up the output scale even more and youre driving so much low end compared to high end that you start to lose definition in both. Fine for full-on-in-your-face stuff thats not too complex, but if youre breaking 200Bpm or using complex chords or arpeggios then youre going to suffer with the clarity loss.
Its not just how hard the signal is hitting the pre - its where, frequency wise, and the dynamics of it. Modern amps have $%loads of gain, or can do. Its true. I never take the gain on my powerball over 5. Ever. For any reason. Thats enough more than enough for anyone in any circumstance. Mostly its on 3.5-ish. I sometimes max out my pittbulls gains just because its so silly that it still sounds good with so much gain, but theres no reason to use that much on that either. I use high-ish output pickups for their voicing and how they respond to playing. Its far hard to get a sound with the right percussion and aggression in the lows and mids from a low output pickup.
Pickups like the aftermath and painkiller use powerfull magneitic fields with quite modest winds to get the best of both. Actives are another way around it.