The endoscopy is no big deal, for me, the worst part was the nasty spray for my throat! They keep you well drugged, and you'll probably say some pretty loopy stuff to the nurses.
I think my throat may have been a little sore and I was sleepy the rest of the day, but I was totally fine the next day. It's a piece of cake!
Make sure someone is with you when the dr talks to you after, I was still coming down from the Versed (amnesiac drug they used) and I didn't really remember what he said. You probably won't remember going home. It's a very wierd experience!
GOOD LUCK!!!