I realize what an elitist knob this makes me sound like but I decry all of this because I've been there before and made the same mistakes. I like your example because you mention a specific issue you had that you then went on to fix. I know of many who train this way when they have no ailments whatsoever.
I ended up having multiple bulging discs from C5-C7, a severe disc herniation in T8-T9 (which happened mid workout, very painful), L4-S1 herniations and L4-L5 breaking away chunks of my vertebrae. I eventually had to get emergency surgery on C5-C7 due to the narrowing of spinal cord.
I still "work out" with resistance bands, but I'm never allowed to properly lift weights again thanks to my foolishness. It's horribly depressing and I don't wish this on anybody.
Moral of the story is you might be just fine and have the skeletal structure to support lifting, or it could be a ticking time bomb like in my case. Lifting goals should carry disclaimers about the possible dangers.
I hope the recovery is going smoothly now at least :/
I did dead-lifts several years prior to the injuries and stopped those when I had a funny "clammy skin" sensation in one of my arms; it freaked me out a little and I hated deadlifts anyway so I always thought it was just my excuse not to do them, but in retrospect I think that was probably a wise decision.
Not saying there is nothing wrong with having lifting goals either. But there are definitely diminishing returns to your health in regards to the amount/intensity of your exercise routine for sure.
So I really think if you are an athlete/ex-athlete and you really know how to train - go for it. My main goal was not to have a back pain ever again.
Every single ailment that I've had that is not an injury disappeared when I got into shape (and read Sarnos book).
You know the picture. Spent tons of time playing video game and works in an office since forever. I can't afford physical therapy, but working out + good posture makes the pain goes away "magically".
I say "magically" because I am not doing anything to target it, just go to the gym and literally do whatever for 30-40 minutes every other day.
Sarno's argument is essentially that emotional distress (mainly, rage) manifests itself in the body through TMS (tension myositis syndrome), and that depending on the person this expresses itself as a number of different ailments (sciatica, back and neck pain, migraines) with the same underlying cause (stress that results in decreased blood flow and oxygen deprivation which cause pain in the related area).
Swimming/soccer/tennis are other sports I'd put in the category of aesthetically pleasing.
Plus rock climbing is fun and mentally challenging, like chess with your body.
It's a true full-body workout (including the brain).
An example from literally yesterday. Over the past few months, I struggled with medial knee pain that was limiting my ability to walk up stairs and do other activities (see other list of goals from above). I had a bunch of observations (pain only when going up stairs, pain goes away oddly enough when running up stairs, clicking noise in knee before onset of pain) but I hadn't spent time trying to root cause it.
I had done a bunch of Google searches but to no avail (with scary things like surgery showing up on the list). But then of all things the YouTube algorithm came to the rescue and recommended this: [1]. Turns out it was a weak Gluteus Medius that allowed my femur to rotate medially which in turn caused the kneecap to track in an unnatural way. Once I knew this, I "fixed" it in a day. But it won't stay "fixed" unless I focus on strengthening that muscle.
Figure out what you need to do to provide you with sufficient functional strength, focus on root causing pain and then addressing it. Don't ignore the foundations of your body.
[1] https://www.youtube.com/watch?v=kbe_DqMJfzg