I believe that a looser G string will sound less twangy (sort of like why short scale basses tend to have a thumpier tone)...
...if possible, I'd always try to get a slightly lower tension G string than the rest of the strings.
This is kind of interesting as my personal experience is the opposite.
My J bass wore a set of D'A Chromes 40-60-80-100 for 4 yrs. The 100E went all thuddy, while the 40G stayed annoyingly bright even after 4 yrs.
Then I tried the Fender 9050L (45-60-80-100) and found the 45G a lot more agreeable as it balanced so much better with the rest both tonally and tension-wise.
Then the Sadowsky flats (40-60-80-100)... Again, just like the Chromes, the 40G did not balance well with the rest.
Meanwhile, my Jazz bass also liked the GHS Pressurewound (44-58-80-102) and the D'A XL Nickels Balanced Tension 45-60-80-107. No problem with a twangy G.
I'm starting to think this could well be bass-specific, though; it's my J that doesn't like 40G's. For example, the same gauges of the Chromes (40-100) sounded great on my old MIM P bass.