I had to have both this year - separate times of course.
The twilight sleep was pretty easy to wake up from - about an hour and they said I was fine for my friend to drive me home.
Of the two - the upper endoscopy caused more post procedure discomfort. A few days to go away. Even with them nipping off a polyp with the colonoscopy.