I had an endoscopy a week ago and opted for no sedation as I didn't have anyone to drive me home. It was not a nice experience,  I panicked and felt I was suffocating,  the medical team were great talking to me to calm me down amd remind me to breathe. It was all over with very quickly.  In my opinion without sedation its managble but not a nice experience.  If you do have someone to drive you home then get the sedation 100%!