The OP posed the question what would YOU choose to play. I'm not sure why you keep trying to steer things around to what you would play when you're being paid to play somebody else's music. Of course, in that case, you'd play what they tell you to play. That doesn't really have anything to do with the question of "what would YOU choose?"
The scenario of "you are being paid to play somebody else's music" is, I suspect, a VERY SMALL portion of the total combined playing that is done by all the TB members put together.
I disagree completely. On the local scene, most people who ask you to come play, sit in, or be a part of a band don't have in mind the instrument they want you to bring and play. All they know is they want it to sound good and fit when you show up. It's difficult to know what their expectations are when they probably can't voice them either, but there are always expectations. Sometimes you can just show up with any instrument, play and they'll be happy. Other times not so much. There is no rule book to navigate by in every situation that guarantees success, however I'm strongly confident that playing nothing but a Stingray would be severely limiting over the long term simply because it just isn't the tone most people have in mind when they are looking for a bass player. Others will love it. I've experienced it both ways with Stingrays. The tone of the Ray was so intoxicating for me personally that it became hard for me to enjoy playing anything else, yet I had situations where other people wanted something else. Ultimately I had to quit playing them because I just felt like I was becoming selfish with hearing what I wanted.
The light bulb really went on for me once when I was part of a live recording where I used a Ray. I remember thinking how killer the stage sound was, but listening back on the recording the Ray was just all in your face. The bass itself still sounded great on the recording to me, but it was almost like it was a featured instrument. It didn't fit the vibe and I realized how offensive it was in the mix. The sound guy who was listening back on the recording with me was very polite and said nothing, until I made a comment about how the bass wasn't sitting back under the band as I felt it should for that genre of music. He simply said something like "Yeah, I cut a lot of mids out and boosted the low mids but it still has a presence that is not as easy to control." That was his way of saying he was fighting the instrument. Literally the next live event I brought a P bass and everything was perfect. I still enjoyed the tone on stage, but the band mix was perfect and the instrument sat right where it needed. Sound guy was stoked also.
That's just one example, but it goes both ways. A friend who is a guitar player had me come over and lay down a track for one song he was doing, and he specifically asked for the Ray because he had heard me play it out a bunch of times. It worked fantastic for that.
Not saying it's one way or another. All instruments can have their place. There is no need to be dogmatic about it, which is why I pushed back initially on this notion that "Rays and Wals are somehow better and more flexible" when there is just no evidence of that, and if anything evidence leans in the other direction though I don't buy that either.