BSD and Metallica aren't really 'mode based'. They both have a few 'modes', but they're circumstantial things. For instance, in Metallica hitting enough ramps starts Lady Justice, which is basically just timed super ramps, or hitting the Fuel target enough starts Fuel, which is basically just a frenzy. Both are just something that stacks on top of normal play. There's also Battery and Seek and Destroy, iirc. I'm not sure how to start them, but I get the impression they're similar. BSD is the same way, it's got a few things like Bats but it's just a small one-off thing that stacks on for a while after you do a certain sequence of things to qualify it.
Metallica does have Crank It Up, which I suppose could be considered its 'mode', but I think it'd be more accurate to call it a mini wizard mode. Four different modes, each set to one of four songs, with their own rules for how to score points. Enter Sandman is pretty cool + hard, the other ones are just 'shoot all the shots 3 times', 'shoot sparky a lot', and switch hits. They're mostly fun to play, but considering that you need to play for a good amount of time to even get to them, and you won't at all half your games, I feel like it's not the same type of 'mode based' gameplay you're probably looking for since you referenced TAF, TZ, and JP.
IJ has a lot of modes, maybe the most of any WPC (?), but I agree with you, they're mostly pretty boring. Three of the 12 are video modes, and a good portion of the rest are just 'this shot is worth more for 30s'.
WOZ, again, isn't really mode based, but it's got a lot of stuff that could be considered modes spread throughout the code. There's stuff like the crystal ball, which'll give you a random 'mode' such as 2x scoring, but lights out, or flippers reversed, or something, or the spinning house which will start a few different frenzies.
TSPP has ~8 modes startable from the upper playfield TV shot, and relit via the right orbit, but I find them mostly ignorable. People just stack on as many as they can while they try to get to multiball, and hope the points'll just come to them by accident.
Tommy and Last Action Hero also have a good quantity of modes. Last Action Hero works just like TAF. Shoot ramp to relight, bumpers to change, scoop to start. Nascar has a ton of modes. Most Lawler games after TAF are probably worth investigating, I think they all have some modes.
Mustang definitely has a few cool ones, once you learn what the hell is going on.