For background I'm in my mid 50s, never did weight training in my life before 2019. I've progressed more I thought I could and my muscle tone and strength is better than it's ever been in my life.
However none of this has changed my outlook on work, or accomplishing other stuff in general. It hasn't unlocked any new drive or energy or passion. I don't feel like a different person from before. In fact I am tired earlier in the evening and sleep more now.
I don't say this to be discouraging but personally I've never found that "just do this one thing you're not doing" will make a dramatic difference aside from getting better at doing that thing. If you want to get strong, lift weights. That's good in its own right. It may or may not change anything else in your life.