In my personal experience for a day procedure (gastroscopy) it was fentanyl + midazolam, although on another occasion for the same procedure they added ketamine for some reason.

In the latter case I actually remember more of the procedure - although I was completely detached and thought it lasted about a minute (it was a 10-15 min procedure). In that case I can recall having the tube removed and passing out what seems like instantly.