Have you experienced sedation dentistry?

I have an appointment coming up to discuss my options to calm me during treatment for an extraction and potentially a root canal as well. I am pretty much petrified of going to the dentist which plays a part in my teeth getting to this point so I’ve sought out a practice who uses sedation dentistry. For those of you who have used this method, what was your experience. What was it like going through the procedure? (to be specific I am not talking about general anesthesia but instead IV sedation, nitrous oxide, or oral anxiety medications.)