easy answer: if you use lots of pedals, the riff raff is king and will do anything
I play mostly a '73 les paul custom that had many many bkps
My favorites were the bridge riff raff and neck mule, BUT now it has a rebel yell in the bridge position and it sounds a lot like the riff raff with a tube screamer set as a "clean" booster
the rebel yell is not as woody as the riff raff or as organic as a bridge mule, but it retains the brightness and a lot of the midrange openness, but delivering more compression, sustain and MIDS: it has a huge upper mid bump without getting honky or annoying
I still wonder why I avoided the rebel yell for 13 years of bare knuckle pickups

the riff raff is still my favorite for its versatility and woodiness, but the rebel yell is now my second favorite
the cold sweat set was my third favorite in the les paul custom
the bridge cold sweat has a somewhat similar voicing to the VHII, with a big low end and recessed mids, but the thinner wire and ceramic magnet response makes it brighter and more compressed, but I have no idea how it would sound in a semi-hollow
it sounds somewhere between the vhII and miracle man
it is a hot pickup, no doubt, but it's not as compressed and harsh like similar spec ceramic pups from Seymour or Dimarzio
the VHII's midrange is also a bit midscooped and they have a nice amount of treble, but I wouldn't call them BRIGHT pickups
they're like mules, but louder, punchier, bassier and drier sounding
they do hold some of the riff raff and mules woodiness, but I find the bridge pickup to sound a little too dry for my tastes
I actually loved the neck model installed in the bridge position, as it sounded somewhere between the bridge riff raff and bridge mule
as a bonus, I also loved the neck cold sweat in the bridge position of another les paul ('78 Greco with rosewood board/maple neck)
not sure it would fit your bill, but it sounded a lot like something Paul Gilbert would love and endorse
it's bright like a riff raff, similar output too, but it has a more colored midrange, not really PAF sounding, not as woody, but still non-compressed and EXTREMELY articulate
the lead tones were stellar
the only time I used that on stage, I got more compliments about my tone than ever
trying neck bkp's in the bridge position has opened a whole new world for me
too bad I have very few guitars and tend to install all pickups in the same one for reference