I had the best effect managing pain with high CBD low THC strains - meaning strains with over 7% CBD and one percent or less THC. If you vaped or smoked them, I am surprised that they made you stoned - all the pain-free people who have tried it with me have complained that they didn't feel anything at all. For me, the pain relief is so profound and quick acting that I can pinpoint the second it starts to have an effect.

Eating cannabis has very different effects to smoking it, due to liver metabolism. I am not sure what it does to CBD, but the psychoactive metabolite of THC does not have the same effects. Eating cannabis is more than just a different delivery method - it's essentially a different drug entirely.

Unfortunately, while I found CBD strains most effective for pain, I personally have not been able to tolerate them - they cause me memory problems that I have not found any mention of in the literature, not anyone else who experiences them.

It's important to note that, unlike opioids, cannabis doesn't make the sensation of pain less strong, it makes it less urgent.

This means that if you won't necessarily feel a direct effect on the pain, but that its subsequent effects aren't as strong - the pain is not as exhausting, distracting, or debilitating.

I would say try edibles as others have had positive experience and relief, but my body digests it too quickly and usually doesn't do much (tricks to eat high fat food before, but doesn't always work), so I haven't had too much luck.

However,

What I actually recommend, and has helped for many of people, is the Phoenix tears/ Rick Simpson oil regiment.

You can buy premade oil marketed as such or Rick Simpson provides diy on how to do this yourself.

Essentially it is ingesting small amounts of concentrated cannabis oil daily, like taking a prescription.

It vastly helped my mom's Chrons and I know of a few people help with chronic back pain