Personally, I worked myself into the ground trying to both advance my career and to manage increasingly alarming health issues.
I would have benefitted from some “real talk” but that’s not baked into the contemporary western transactional model of medicine outside of those areas that routinely deal with terminal illness.
It can still become addictive, after tremendous amounts consumed over long time that don't make sense unless you just want to fuckup yourself as much as possible. But plenty of folks still end up there.
But its one of the easiest addictions to shed off, compared to say cigarettes, alcohol or well anything else (I would say even sugar is more difficult to wean off since its everywhere, joints not so much for now).
It has positive effects - pain management I guess especially with edibles, but for me its change of perspective/mindset on life matters, much higher creativity, michelin star level of taste experience even from relatively cheap food, and that sweet sweet high that is just so relaxing.
But it will make you overall less patient, which sucks. For parenting, for work, for life in general. Also, morning after is much better than alcohol binge night, but mental gears running on 20% isn't something that helps produce quality in your work. Plus most consumption methods mess up your lungs pretty badly, but quality vaping is I think cca good enough to not shorten your life considerably.
I don't know your situation, but I wonder if it seems this way because doctors don't have many options for treating chronic pain. There are medications for acute pain, but when you use them chronically over many years—well, that's how we ended up with the Opioid epidemic.