Marydoll
I suppose there are lots of variables at play, including the skill of the clinician performing the procedure, our own medical circumstances and how we cope with pain or stress.
Agreed. Whilst I can understand that some have a need to leave the hospital ASAP, and sedation means that you need to 'come round' and have a lift organised, I wouldn't want to have the procedure without it, and there is no need to do so (or to have one without adequate sedation) if the patient doesn't want to. As the OP said she hated her last one, it's fair to point out to her that she can have it done without trauma.
My husband drove me to mine, armed with a crossword, a book and his iPad, but he wasn't allowed to stay in the waiting room, so he went home and the receptionist called him when I was ready to be collected. If we had lived further away he could have gone to a cafe or something and waited there. I think it took a couple of hours including the time in the recovery room.