This is very personal, some like chunks and others light weights (as me).
Sounding better or worse can't be defined by words neither by opinions.
The one that sounds right to you is best*, better think twice before modding** it.
And influencing gear's sound is about 70-80% in the fingers imho...

*don't get twisted by a 100 opinions, this is always a lonely decision!

Make a list of the top 30 albums which you love the bass sound on. Then, filter out the ones which aren't Fenders. Then, write to the bassists involved asking if the bass was heavy or light. Then, publish the results.

Jeez... everyone's a comedian.
(Except for a couple of serious replies.)

Weight affects tone and the responsiveness that you'll feel. But it's only one factor. You mentioned pickups, but don't forget the type of strings, the particular piece of wood (and its species), your attack, the type of bridge, the type of amp, etc.

This is not a topic that you will likely get a general consensus on. I've heard knowledgable people say lighter bodies resonate to a frequency that makes for better bass tone. I've heard others insist that for a good low end, a heavy bass beats a lighter one. There are a number of Sadowsky owners who feel the lighter, chambered bodies of the NY Sads have a slightly better tone than the solid body Metros. Others insist that they hear no real difference. In other words, this is not a topic that you will likely get a general consensus on.

All depends on how strong the electromagnetic field generated from the earths core at any given location in time on the planet ,but if the bass is too heavy i suggest you take it to the moon it will be much lighter there..... though it may not sound any better