I just had one the other day, unrelated to my anxiety (I'm currently worried about schizophrenia, the colonoscopy was just a routine thing). It's not bad. The prep is really, REALLY a drag (the worst part, for me at least, was not being able to eat real food for over a day). Make sure you have a bathroom available to you at all times. You will easily go 20 times over the course of the entire thing. The good news, though, is that the procedure is nothing. They give you a sedative and a narcotic so you go into this "twilight consciousness". I only remember a little from the procedure, and none of those memories were painful or uncomfortable.
As for the results - the doctor/nurse will tell you right away if there's an issue. They'll give you definitive results within two weeks.
I wouldn't worry. Bright red blood, in small amounts, is almost always hemorrhoids or fissures. Diverticulosis is the next most common cause, followed by inflammatory bowel disease or large polyps. Cancer is behind all of those.