I do agree about the 40G being a bit thin and light. For me the problem is the 65D, which is noticeably tighter than the rest. This is why I've always preferred a set with a 45G and a 60D, or something close to that.
IMHO, and I opened a topic about it, it's all a matter of setup; far too often people judge strings without doing a proper setup to the instrument, and then find strings being too tight or too soft, but maybe they just need to lower or raise the saddle half a turn.
I do prefer 45-65-80-100 strings better than "balanced tension" or 45-105 because I find that they match better with a proper setup: a tight A string, with a tension similar to the D will be comfortable if lower on the fretboard, so the actual feeling while pressing it is of a softer string.
a smaller A will need a bit of air between the frets, and so the feeling will be closer to the D, also considering the different position of the fingers while pressing!
a G string is nearer the hand, so you have more strength; an E or A string is far from the hand, and you need to use more strength to press it, so a lower gauge is useful.
I have 45-100 strings on all my basses right now (two with EXL170, one with ECB81) and they are alla perfectly comfortable and balanced, except a Jazz with Labella Jamerson 52-73-95-110 on it.
these Labella are strange, a world on their own, but for example they have the SAME tension as Ernie Ball 50-105 nickel strings... weird!
I switched from EB 50-105 to Labella 52-110 four times on four different basses (some time even viceversa), and the neck never needed any kind of truss rod setup.
even being so large, they are still flexible and not so tight.