Not really mainstream rock, but I've been practicing a lot of Sepultura lately. Mainly guitar, but I also tried with my '83 Spoiler and it struck me how it sounded exactly the same as the bass on Chaos AD (through my Line 6 Ampeg simulation)
I'm pretty sure Paulo used a classic SVT combi and either a 5 string Essence or a 4 string Spoiler. Good example:
Click here (try @ very low volume first)
Even more extreme:
Click here (turn volume more down) :-) That's an all Maple (except Ebony fretboard) Elan through an SVT
Now the next seems more like mainstream :-) (though I guess it actually is mainstream today)
'tallica! :-) I'm pretty sure this is recorded with an Alembic (JPJ Elan, Spoiler or Exploiter Spoiler) through an SVT:
Breadfan Live recordings with Series II basses through SVT's: (lots of 'em)
San Diego 1992 For more mainstream look also into Level 42 and Prince, should be a lot Alembic there. I have now clue what on which song, there might be someone here that can be more helpful on those.
The only Essence I know of for sure is on the Sepultura album, It looks like a quite standard 5 string model with a Vermillion top (or something that looks familiar)
The Elan on the Gorefest Album is specswise almost identical to the Essence, it has another body/headstock shape and slightly more versatile electronics (probably extra trimpot for individual pickup gain settings and a Q switch, last not being a factor in this case (I'm pretty sure the Q is on in the recording, as is on the Essence electronics package)