Not too long ago, regulations on CBD changed in Germany leading to a plethora of products containing it. As someone who occasionally needs pain medication, I tried some of the products to avoid regular pain killers (ibu). Especially on days with lighter pain, I wished for an alternative to the sledgehammer meds. But I was left standing in the rain. I didn’t feel any effect. That’s why I would love to hear from your experiments and experience.
You’re getting a lot of answers from Americans. Be aware that CBD oil sold in Germany (Dm, Rossmann, etc.) almost certainly doesn’t contain significant levels of THC.
The evidence doesn’t seem to suggest CBD alone is effective in pain management:
https://www.health.harvard.edu/blog/cbd-for-chronic-pain-the-science-doesnt-match-the-marketing-2020092321003
Cannabis oil that contains THC is almost certainly a different matter.