There is no such thing as "good weight". People like Michael Clarke Duncan still die "young" from heart problems. The strain on the heart for pumping blood is related to the mass pumped through, not the percentage of it that's "fat". Arterial constriction/hardening through lipid action is a separate issue, but for general heart failure, and a variety of heart diseases, there's nothing that indicates there's "good" weight, just that any added is harder.
There is certainly good weight. As with many things, it is a matter of degree. Michael Clarke Duncan was a bit of an extreme case, at 6' 5" and 315 lbs. The thing about muscle weight is that you have to work to get it, as opposed to fat weight where you just have to eat. Building muscle also strengthens the cardiovascular system while eating pie does not. So I would still agree that everyone should do some sort of weight training. You don't have to get huge, just put some muscle on your frame. It strengthens your joints and bones as well.
Having a decent baseline of strength makes life easier, helps prevent injury and will carry you into old age as a healthier person. You don't need or want to get as big a Dwayne Johnson or whomever. You can't get that big without a huge commitment, and steroids and hormones anyway. What I'm talking about are people like Jack Lalanne. He was strong and fit his whole life and lived well into his 90's. He wasn't a bodybuilder, but he was strong and healthy. He was also an extreme case, but he set an example that people would do well to follow.