I've had a colonoscopy and yeah: it's a nothing procedure. You're anesthetized for it and there's no recovery period so its just been and done. You also feel great afterwards from the prep medicine (at least I did).

If you have the money, I recommend a bidet toilet seat (which I recommend anyway) before you do the prep for it - makes the whole process a breeze.