My friend had one of these recently and she said the hospital staff were really against her having sedation. She is like me and gets very anxious. I myself have a severe gag reflex and would never want it done without sedation.
My friend had a very traumatic experience and I felt very sorry for her - poor thing.
I thought it was standard to be offered sedation for these kinds of procedures. Surely it's really unfair to expect someone to end up panicking and crying at the thought of it.