Glad it went well for you. I think that the great majority of biopsies are as you describe.
Personally, I prefer pain to sedation. Sedation of most kinds make me sick for at least a day. I rarely go home from out patient procedures because of nausea and vomiting.
So I do colonoscopies, cystoscopes, even uretoscope without ansthesia.
Probably another thing is I hate being out of control.
Good luck on your journey.