Relax!! IMO you're over thinking this. Every one compromises especially at the start of the long journey that is becoming a bass player. You don't need great gear to be a great player, you just need to put in the hours and develop a good technique. That's the one thing your shouldn't compromise on. For everything else you can build up to the "best". Anyway, you're idea of what is "best" will certainly change over time.
At the start of their careers, the guys you mention didn't worry about their gear. They just bought what they could afford, worked out how to get a good sound out of it, then played their butts off. Many people start on a Fender and nearly as many end on one. Very few players only play one bass their whole lives. I started on a used Framus Star Bass. That was all I could afford. After 2 years I bought a new Fender P bass. After another 25 years I bought a used Musicman SR5, now (after 50 years) I have my "best" a Sadowsky J5. I'm old now but I know most of my best playing was done on that "ordinary" P bass.
Gear is just stuff. I'd say that a Fender is a good starting point. If, after a few years, you think you've out grown it, that will be the time to decide what the next bass should be.
Anyway, be happy and enjoy your playing and you'll be a better player.