I used to have a VHII in the neck position of a Mayones Setius with mahogany body and maple top, and a 5-layer mahogany/maple neck. It was the best neck pickup I have ever heard and it splits like a champ, very authentic singlecoil sounds!
The Cold Sweat is nice as well, but I have never quite figured out why it is praised as the best neck pickup ever, which it is not... Do not get me wrong, it is a nice pickup and I do have it in the neck position of my Les Paul, but only because I did not have a pickup cover for the VHII. I think it is too bright, and it does sound a bit weaker and not quite as fluid and smooth as the VHII, even though they are pretty similar output wise.
VHII is warmer as well, which I like in a neck pickup, but not all the way towards jazzy territory. The only reason why I do not have in the guitar anymore is because I decided to turn the guitar into a straight up metal axe, and install a set of EMG 81x/85x. The 85x is not as nice as the VHII, but the 81x is just heaven for heavy riffing, so it was worth it after all.
So do yourself a favour and order a VHII, you will be very, very pleased!