Hi,
I have the CS set in an otherwise stock McCarty. A lightweight and resonant, warm but clear guitar with a good deal of midrange. The Cold Sweat was recommended by Tim and it was definitely the right choise! It's aggressive and has cut, but you'll never describe it with the word 'harsh', with my guitar.
Interesting note about choosing the pickup for a guitar :) And often very true!
I had both of my current electric guitars for a good while before deciding that I'll replace the pickups. It wasn't a change just for the sake of change, it was because the guitar was not sounding like I wanted it to and the vision had cleared (over time) what I wanted the guitar to sound like.
Another interesting thing in achieving goals with guitars: if your guitar has a tight bass (like a lot of maple wood which tends to tighten BOTH the bass and the highs) and you choose a bottom heavy pickup for it, you'll get a different flavour than if you have a guitar with a lot of loose bass and pair that with a very tight pickup. Both combinations will more or less have the same amount of bottom end, but in the first case, that bottom will be tighter..and the same thing of course applies for the other frequence areas too :)
-Zaned