Transfer with no anesthesia?

Today I went in to do my SIS and it was the most excruciating thing I've done since having and iud inserted. I went into this appointment full of anxiety. There were a bunch of things that weren't working in my favor. 1) I have a low pain tolerance. 2) i have a history of trauma so gynecological procedures cause me to have panic attacks. 3) the dr had difficulties get past my cervix which cause most of the pain. I mentally prepared myself for today. I told my self "YOU GOT THIS", I took a xanax and 800 mg of ibuprofen 90 minutes prior to my procedure. I communicated with my doctor my needs prior to the start of the procedure. And lastly I had an ear bud in playing music to focus on anything other then the procedure. Once the procedure started so did the tears and anxiety. I gripped the bottom of my first as tight as I could as I grimaced with every ounce of pain I felt. I pushed through and I made to the end of the procedure I thought the hard part was done. My doctor sat me down and told me that the egg retrieval would be done under anesthesia and I should be fine. But then she told she was concerned about how I would handle the embryo transfer if I barely made through the SIS. I was confused I thought the ET was gone under anesthesia just like the ER. She informed that it was not. She went on to say that she was very patient and accommodating with me today but that the dr doing the ET may not be as patient with me. I am at loss. It took all my will power to get through this exam. Now I'm left questioning how I will get through the ER. Is it normal to not use sedation? I'm working with INGENES if that makes a difference. Any advice or encouraging stories are welcome.