My recent colonoscopy used fentanyl. I wasn't loopy afterwards but we did (as directed) arrange to have someone else drive me home.

All in all, I really appreciate the loss of memory formation, since the most annoying part of these procedures for me is the boredom. Just splice all that out, thanks.