Yes and no, for years I had an hour or so late night (11PM ish) when my brain worked a lot better and I was physically a little more capable. I'm not sure I actually felt better, in fact I'd say not, that was the time I would notice I'd been in pain forever etc. - but it was the time I got things done.
Doesn't happen so much these days, generally I'm wiped out before my brain would pick up and that stops it dead. the closest I get is the period a few hours after taking opiates, largely background pain free, but still a fair amount of surface pain if I have the audacity to move, and of course neuropathic pain which opiates don't touch, but I sometimes feel okay, wiped but okay, for a while, if I've taken the right amount.
Of course they stop me sleeping, and being able to get to sleep is the reason I take them, so...not a total win.