Hi there, I completely respect your feelings on this because I felt and still feel the same way. I have no desire to be "stoned", and didn't really want to try marijuana for the pain.
But I use medical cannabis almost daily now, and it helps me more than any other medication I have been on. I use the tinctures, because I don't want to inhale anything. I mostly use one that is 1/2 CBD and 1/2 THC. I found that by starting with a very very small amount and working up to the amount that helped with the pain, I could reach a dosage that helps greatly with the pain without making me feel the least bit affected by the drug. This period of experimentation took a few weeks because I went at it very slowly, but now I know exactly how much to take and I won't feel stoned. At night I sometimes take just a little bit more, as it helps me to get a full night's sleep, (and if it does make me stoned I don't know it because I am asleep).
So, not trying to change your mind, just letting you know that you can use medical cannabis without it affecting you in a way you don't want it to. I can drive, do tasks, visit with people, be active, have my normal day and never feel under any influence, just have less pain. It doesn't work on every kind of pain and doesn't work all the time, but it has changed my life for the better.