Update here. (I name changed recently)
Today was the day of my sigmoidoscopy. I was a bit nervous, but mostly about actually getting there as I had to go on my own today. The hospital is in a different town, and I don't know it well.
Anyway - I was there early - got taken in to fill out forms etc. Then changed into a gown and paper pants (I initially thought it was a hair net...) The nurse gave me the enema - and left me alone, instructing me to hold on to it for at least 10 minutes. the toilet was in the same room so was all very private and comfortable.
Then sat in a waiting area with my book for about 30 mins.
Then was called into the main room. I was expecting an operating theatre type room, but it was quite small actually. The actual process didn't hurt, it w was a bit crampy and I could feel it right up under my rib area. Very, very strange. It was all done in about 10 mins or less. The staff were all nice, and chatted to keep my mind off it all.
I was then wheeled into the recovery room, where I had blood pressure checked etc and then left to dress in private again.
Offered a drink and sit down, but I was happy to go home.
This afternoon I have been very windy - I could hear it all gurgling around - they pump air in to get a better view. but other than that no problems.
So for anyone who is awaiting this test - it really isn't so bad.