Its all about striking the balance. There is a difference between pushing the envelopes and potential and trying to proof a point because one is insecure. I have seen bassists on stage who thinks they are the ****. You know, those who during soundcheck likes to shred slap incoherent notes which may seem impressive to uneducated musicians but when it comes to the song, they're playing constantly outta time and cant keep the groove.
I have been guilty of being that for awhile. I mean, I tried to slap on my first day of playing bass because I thought 'it was cool'. And my bandmates at that time seemed impressed when I could bust out 'higher ground' albeit its outta time. I find out what a metronome does until a year later
Ultimately, remember that most of the biggest songs have relatively simple basslines. And I do not believe that the bassists(touring and recording artistes) on those song dont have the technical capability to play something more fanciful, but its due to the fact they know their role and dont let their ego get in their way they keep it simple.
I am writing in an original rock band right now, and even tho I try to be flea and geddy lee, I constantly ask myself if its the best thing for the song? Heck, even flea sticks to just root notes from time to time.
Well that's what I try to do, but I the mistake of overplaying sometimes