90%+ of the bands I've worked with have preferred the sound of a Fender-style bass to all others, and its not the headstock (some of them have been called Lakland, Sadowsky, Yamaha, etc). The Stingray and the Jazz Clones are the only active basses that get the same kind of smiles, but in many cases the passive basses do even better.
Its not just our ears and our music that are used to the sound (though those are both true), the other instruments in the band have been developed over the years with those sounds in mind, so they leave specific frequency zones unused that they want the bass to sit in. Usually, while you can get some cool tones from other basses, you end up playing a square peg/round hole game with them in the mix, and I've been asked many times not to bring those basses back. A great engineer can make the other basses work (basically compress and EQ them into Fender type parameters), but pretty much anybody can get an appropriately chosen Leo style bass to sit in a tasty spot, so you can get back to worrying about dynamics, note choice, not duration, creating space and vibe. The stuff you should be thinking about.
Its not closed mindedness either. Those "other" basses really do sound weird in the mix most of the time. There are exceptions, and other basses that can be great, but you really can't loose with a Leo design for rock, funk, blues, raggae, R&B ... any "band" music really.
IMHO/YMMV -- but those who disagree, I'd suggest opening your mind to the idea that a Fender might just sound best and give it a real try.
Edit: its not 100%, more like 90%. Some bands have liked lower-fi basses like my old Guild B-302. Nobody has preferred a modern active bass though.