Don't listen to
@Chris Fitzgerald, he drinks in the morning. Sure, there are preferences and I think that people who prefer Spirocore Starks, for example, have built up to that over time. New DB players coming from BG usually prefer lower tension strings. How you play with your right hand is a major factor in how you want your strings to respond.
But, there are basses that need more tension to speak. There are other basses whose tops will not vibrate beyond a certain point. I have a bass that I think physically would fail under a certain amount of tension. If I were shopping for a new bass, this is one of the main things I would be evaluating. I'd be looking for on that sounded and felt like I wanted it to under Spirocore Mittels. I've played basses like that, for mine to sound and feel the same, I have to go down in tension.
Set up can and does make a difference, up to a point. For normal, healthy basses, with enough setup, probably anything is possible. For older basses with tons of "character" often you have to work with what the bass wants and can handle.
But read a ton of our lengthy threads on specific strings and see how differently they are one bass to the next. Sometimes even literally the same string. e.g. - I try some strings, opine on them, maybe make a recording and then mail them to you and you're opinion of that string is totally different. Someone also recently commented on something that up until that point I was the only one who I had ever heard claim this - that the character of a D string changed based on which G string was installed next to it. The cumulative and neighboring tension effects not only the string, but other strings as well.
As has been said, they are really complex instruments, especially older ones. Find what works and try to stick with it.