hi patt
i've had several of them and had very little pain....
i doubt insurance will pay for the extra time in hospital.
ask your dr for a couple of sleeping pills to be used at home before and after the procedure. in all probability they will give you something to relax you before the procedure.
this procedure used to be a lot more painful but nowadays its not bad......pete