Most every top notch bassist does not play an instrument that costs thousands.
Some do.
It is absolutely true that the “tone is in the fingers,” presuming one is referring to knowledge, skill, feel, execution, etc. That is your starting point.
The instrument needs to fit the gig. That might be a dumpster diver for a punk gig, or it might be a showy Fodera if you are backing up a big name tour. Just depends on what the folks at the audition are looking for. You can be either over dressed or under dressed, and not get the gig.
Hone your skills, get experience, and play instruments that make you comfortable on the gig. The rest will take care of itself.