It all depends on what you want your bass to sound like, and what you're running it all through. And your playing style. And the bass itself, but not so much as your playing style and the sound you want.
There is no such thing as a classic hardcore bass sound. It would be easy if you were a guitarist, because a hardcore guitarist needs three effects: Distortion, distortion, and distortion. But the bass is different in any rock band, because it's variable. I'll show you some examples...
Lemmy (not hardcore per se, but definitely a good example) liked lots of mids and a natural overdrive to his sound. Cliff Burton liked using a compressor and distortion. The guy from Anthrax (I forget his name), meanwhile, liked the sound of a crystal clear bass against the distorted guitars. It was a nice contrast, and his playing made up for the lack of effects.
Those are just three examples, there are millions more. What you need to do is head out to the nearest music shop, with your bass, and ask to try out their bass effects. Then you'll be able to decide, and you won't have to depend on guesses from total strangers.