I’m not an expert on pickups and someone that is can pick what I’m about to say apart, but it’s my takeaways from experimenting so if any of this helps you then that’s great.
In general, the more you overwind a pickup, the hotter it gets, but the EQ shifts. More mids, less top end. There’s more to it, but that’s the vastly oversimplified version.
IME, high output ceramics tend to sound thick and tight into higher gain, but somewhat akin to wet cardboard into a clean channel. It’s what‘s lead to a lot of people developing a distaste for them.
Alnico has a bit of a different feel to it, and that feel varies depending upon type (most common in guitar pickups is alnico 2, 3, and 5). A2 is arguably the most vintage sounding, with A3 sounding similar IMO. They have a bit of a spongy feel that softens the attack, makes it less strident/sterile. A5 is a bit more modern… slightly more output than A2, tighter, but more scooped than A2. I think A5 is seen in the bridge more because it has better bottom end, and in the neck it has a tendency to get too muddy.
When I was younger I hated the JB (A5 magnet) as it was too squishy and didn’t have enough definition for my tastes. Now, after a decade of playing through mostly A2 bridge pickups I like the JB (A5) as it’s a good compromise between the feel of A2 and the tightness of ceramic.
(side note, I’m pretty sure the Distortion is a JB with a ceramic magnet, and I think a Tremonti is supposed to be similar to a Gibson 500-T)
I don’t know if that helps, or just makes it more confusing, but there it is.