I’ve found that with medical marijuana you still feel the pain but you just don’t care because you’re stoned, granted I haven’t had pain such as yours.
With ketamine, at low doses you get a disassociated effect without much cognitive load but I haven’t taken it when I was in pain and unfortunately don’t have ready access to it anymore.
I’d taken Vicodin for 2 days after a surgery and quit it immediately because I couldn’t think clearly, nausea, etc and didn’t want anything to do with it.