Not really. Most of what the rider has to deal with it stuff that's low-frequency for the tires to filter out, so heavier just means more mass for you to wrangle.

It's often worth paying a price in weight for something, but the weight generally isn't a benefit in its own right.