Conscious sedation in dentistry exists for exactly this. Not as a way to avoid your treatment, but as a way to be present for it without the distress. Understanding how it actually works, what it does and does not do, and what makes it safe tends to reduce fear more than any reassurance, because the fear is largely about not knowing.