Hi I had mine out 2 weeks ago at the hospital under sedation.
Everyone was very nice and friendly. I was lying on a normal hospital bed instead of a usual dentists chair.
They put an IV into my arm and pushed some sedation meds through it. From here on I was awake but didn't really care about things. I just lay back with my eyes closed and my mouth open. It felt like only 5-10 min passed but it was almost an hour.
Once I was sedated they put local anaesthetic into my gums and pulled out the teeth. I felt nothing other than some fingers on my face where they were touching me - no pain at all.
Afterwards they explained how to look after things for the next couple of days to the person who attended with me (the sedation makes you forget what you've been told so you need someone with you).
I took painkillers in the car on the way home and again about 5 hours later. By the time they wore off I barely felt anything so I just went to bed. I didn't use any more painkillers from there.
For the first 5 days I could only really drink water and eat mashed potato and things like rice pudding or yogurt. After that I was eating normal but soft food (like a shepherds pie) for another 2-3 days. I was back to eating normally after a week. It's still not fully healed up but has stayed pain free and isn't stopping me being able to eat anything now so I don't mind just waiting it out from here.
I have to go back in a few months to get one more pulled and two fillings and they are going to sedate me again like this time. I'm nowhere near as stressed out about it now (though I definitely still couldn't do it without the sedation).
You will be fine - the staff at dental hospitals are used to dealing with people like us - I never felt judged about the state of my teeth and everyone just wanted to do whatever was needed to help me through this.