I can't remember what I was given to drink for either of mine,
@Gingergrrl, but it was only the taste that was unpleasant. They advised me to add something like orange cordial to help mask the flavour, but after a while, nothing will hide it! I'm well used to having to rush to the toilet, so that was nothing new.
I had the procedure without anaesthetic, as they insisted I had to have someone with me for 24 hours afterwards if I took the drugs, and there isn't anyone with that much time to sit around my house! In the end, I think it was helpful. Whilst everyone else was groggily coming around and complaining of headache, I was sitting up stuffing my face with the picnic I'd taken, and was able to drive myself to work an hour later. I was back at my desk by 10:30 am, a bit fatigued and still ravenously hungry, but otherwise none the worse for the experience.
By the time I had the second one, the combination of ME and psoriatic arthritis meant that I was no longer able to work, but it was a pretty similar experience. I asked the nurse why some people have more pain than I did, and she said the fact that I wasn't at all stressed about it would have made a really big difference. The gabapentin I was on at the time for menopausal symptoms would have helped too, as it's an anti-convulsant and would have relaxed the bowel to some extent. I really hope it's as straightforward for you.