So, if you're wondering about whether lifting is good for your health, you should first identify what outcomes you're aiming for and then look for yourself what interventions increase the likelihood of those outcomes. I cannot provide specifically the information you desire in an economical way¹.
But it's unfair to just leave you with nothing, so here's a starting point in your research (apart from the Wikipedia article on Weight Training²): https://www.ncbi.nlm.nih.gov/pmc/articles/PMC2453303/
¹ For instance, maybe you don't care to be able to run some arbitrary distance. Maybe it isn't important to you to be able to cliff dive. Maybe it isn't important to you to live to 80. Maybe you consider being muscular to be of negative utility on its own. The state space is too large for me to capture here.
² https://en.wikipedia.org/wiki/Weight_training#Health_benefit...
https://time.com/4803697/bodybuilding-strength-training/
It also increases your baseline strength, which is in turn one of the strongest correlates to maintaining health at any age.
We're not talking about crazy hypertrophy type lifting - bench 135, squat 185, deadlift 225 and you will not have rsi problems.
Ironically my RSI began within a few months of starting weight training.
Are there any proven benefits to lifting heavy weight (compared to let say having a regular physical activity such as swimming, hiking, cycling, bodyweight exercises?)