I don't think that I would make any overly general connections, but if you play with a very heavy touch then more tension will keep it from being a clank-fest. If you play with a light touch and let the amp do the work then you may get more dynamic range while using less force by using a lower tension set. But I'll bet that there are players with a light touch that play heavy-gauge sets, and v-v.
For me the switch to lighter gauge and lower tension strings was part of an overall move to play with a lighter touch and more dynamics. I found sets like the TI Jazz Rounds were excellent, but they would get as loud as they were going to get well before I was really digging in. Sort of like a mechanical limiter.
Similarly, a friend was looking for mules to test a custom super-heavy flatwound set and I had them on a P for a while. My hands hurt after 15 minutes, but my bandmates at the time though the tone and punch were exceptional. I agreed, but just started bringing a bigger amp and went back to my usual set.
So be aware that string tension differs between brands and types, and if you think that you would benefit from more or less tension, give it a whirl.
