Not sure what people define as 'great bass tone', but what is important is having a tone that glues the rest of the band together, that fills the necessary sonic space and stays out of the way of other instruments.....that tone could be literally anything (depending on the musical context) and still be 'great'.
So yes a 'complimentary' tone is incredibly important.
Si