A friend of mine has Bare-knuckle pickups in his LP, and they sound amazing IMO. I have dimarzio in pretty much all my guitars - evolution, breed or PAF Pro - all of which fit the bill in slightly different ways - the PAF Pro is the most 'traditional' if you like. If you want hot pickups you could look at Active's as well - EMG specifically.

For versatility, it might be worth considering buying tappable pickups so you can split the coils for more sounds, but it depends how confident you are doing that kind of stuff (or if you're gonna have someone else do it).

It's a very personal thing, so listening to the sound clips on the manufacturer's website and going for it is the only way... if it doesn't quite pan out, chuck em on ebay and try again. Have you found a guitar that has the sound you want for your LP? That could narrow the search for you.

And.... welcome to GT... :D