Mine is a Gibson Les Paul Studio too

The difference with mine is that it uses a 498T and 490R and it's the first guitar I've been happy to leave stock. I'm not totally happy with the 490R but the 498T is just what I'm after so I've left the guitar alone. As for your guitar, I'm going to stick with my suggestion of a Mississippi Queen in the neck because it will do what you want and my experience is that it's superb. For the bridge, I think you have options galore:
MuleThe epitome of the PAF pickup so certainly at the vintage end of things but also versatile as it will do pretty much anything from Blues to early Ozzy Osbourne. Tim used to use these in an Ozzy tribute band. This would be a VERY popular choice for a Les Paul.
https://www.youtube.com/watch?v=f9Qyl4bEBVEThe problem is that on this clip most people seem to prefer the 57 rather than the Mule and you already dislike the 57! Use your own ears and come to your own decision.
AbraxasForget the Santana reference as that's misleading. Think of it more as a beefed up Mule because in essence, that's what it is. Another very versatile pickup that will go from Blues to early Metal and like the Mule, the AIV magnet gives it a sweet tone.
https://www.youtube.com/watch?v=qfANqu0k3qwhttps://www.youtube.com/watch?v=0e2cRu6um6IA bit more mids and beef to the Abraxas.
Black DogIt's a bit different this one but could well be right up your street. Some PAF vibe, very versatile and tight enough for endless gain.
https://www.youtube.com/watch?v=CaqEET376-IIt always sounds very musical to me this one.
Cold SweatFor a ceramic pickup, this is incredibly versatile. It has none of the sterility I usually find on ceramics and suits a Les Paul perfectly. It will cover anything from Classic Rock to Metal.
https://www.youtube.com/watch?v=nl2QzOMMm6wThat clip is a 7 string but you get the idea.
Rebel YellThis is the one I imagine Kiichi will suggest as he loves it and describes it as the perfect synergy of old and new so it has strong PAF characteristics but with a distinctly modern edge.
https://www.youtube.com/watch?v=65zOouArFDohttps://www.youtube.com/watch?v=qum0jkf-bZcBased on the Nailbombs but not quite as hairy and aggressive
NailbombThe most aggressive option you have here. I found it could do anything from Blues Rock to Metal but always had a 90s Metal feel to it.
https://www.youtube.com/watch?v=X2kvQkpz5sMAll this gives you plenty options so it's down to your ears. If it was me, I'd be looking at Black Dog, Cold Sweat or Rebel Yell but that's just me.