They are a turn off. I don't think I've ever seen a great musician playing one.
With the exception of Les Pauls, but that's a substantially different case -- he actually designed them from scratch.
They deeply offend me as wannabee kid-stuff fanboy nonsense, plus -- supporting this premise -- they're just gimmicks about 95% of the time with little that's really technically distinctive. The worst case I can think of offhand was the "Sting," which was nothing but a FJ '54RI they effed-up with that moronic inlay that
everyone rightfully despises so much.
Considering they're aiming this stuff at immature players, it's always struck me that having an artist's name appended to it is more of a sales negative than a positive, as fannish young people tend to like one or two groups and hate everything else with a political-grade passion. Note the hate these things get here from all the more juvenile users who don't hate the bass, but the putative signatories, and have to point out they hate the celeb and his band before they continue on with saying that in spite of that, the bass is kind of cool.
It's a mistake to assume that this concept is successful marketing beyond a certain low price point aimed at kids -- if it even works there. The big makers are foundering, and
lots of their models introduced simply to give the illusion of constant change and novelty fail to be profitable.
I can't imagine anyone over seventeen buying a bass because some bozo's name is on it.