I like a bunch of knobs for tonal options. I can understand that many bassists who play in bands with multiple guitarists, keys, etc. may prefer a P bass because they sound great and can cut through just about any loud, thick mix. Others want a P bass just to groove along to a single acoustic guitar. That's fine too. Some guys also may have little to no interest in endless experiments with tone. No problems there.
I just happen to play in a 3 piece band with a relatively light mix, so I'm lucky to have more freedom to get into funky scooped tones if I feel like it without having to worry too much about getting buried (though I'm not big on super scooped flavors). I'm also head over heels in love with the science behind the sounds and could spend all day playing around with it -- sometimes do. Sure, I could spend every minute of that time wood-shedding and trying to learn Victor Wooten techniques, but after almost 20 years of playing, I'm satisfied with my knowledge of theory and technical abilities. I know I'll never dominate the world of technical chops, but I also have absolutely no interest in doing so. I've never been the overly competitive type and don't feel like I need to prove anything with flashy playing. I log sufficient hours of practice each week for my relatively modest approach to the instrument. So that leaves me with the rest of my free-time to explore tonal possibilities, discovering new tones, and seeing how those fit into the context of my bands' songs.
For example, my 1970 Guild Starfire is my main player. It has an ACG EQ-01 filter preamp onboard. Having a separate low pass filter for both pickups and a blendable high-pass filter (that functions independently of the pickup blend control), this preamp allows me to take the straight tone of my pickups and build upon it, pulling out and emphasizing certain frequencies that can completely shift the voice of the pickup. Having always favored neck pickups in general, a particularly useful thing I've been playing around with is using the bridge pickup's LPF as a super tight, fat low boost, using the neck pickup's full natural signal, and setting the high pass filter to pull and emphasize certain highs from the neck pickup. Pair those settings with the pickup blend control, I get a super unique, yet punchy tone that sounds really excellent in my bands' mix. There's a whole world of sounds there at my fingertips and if a player really gets to know how to use those filters, it's really like opening up a new dimension of your bass.
All that said, in a gig environment, it's probably best to set them where you like them, and keep it to minimal tweaking, but I would think the same way about my amp EQ and that doesn't make it pointless by any means.