I have had 6 colonoscopies, and 2 bowel surgeries.
For each colonoscopy I have had sedation, and analgesia.
In my area they use Midazolam for sedation, it is given IV, and Fentanyl for analgesia, also given IV. You are not asleep following these medicines - just a 'don't care' attitude is the best description. You may also be given some Buscopan IV, this acts as an antispasmodic, and it helps the endoscopist to move the camera with least discomfort to you..
Once the camera is inserted, your bum is covered and you can see the screen clearly. I found it fascinating. Lots of pictures taken, and all images will be explained to you, along with where the camera is at any point.
An assistant will be beside you, and hold your hand if you wish, along with checking your observations, and chatting to help you relax and be less worried. You will also be offered Entonox or similar, this also works, it does make your mouth dry though.
You will not have to 'beg' for sedation or analgesia, it is offered always - although you will need someone to drive you there and home.
As others have said, the prep is not the best; if you canhave a morning appt for the camera it is best!
It is a worthwhile investigation to be done, it is invasive, but everyone works their best to keep you comfortable, and to find out the cause of why you are bleeding and anaemic. Chat GPT, while useful for some things, it has no place here. Please listen to your Doctor, or find another Doctor.
You will be given a copy of the report from the team before you leave, and have an idea of future plan of care, or the next steps.
I hope you are reassured.