Watching a parent and brother-in-law succumb to cancer, it really is a no-brainer. And it really isn't that big a deal. It amounts to just one lousy night. (That having been said, after I had one this year and the Dr. said "see you in 10 years", I definitely did a mental fist pump. )
As for people being sore afterwards? The scope is smaller in diameter than what my 40 lb dog pinches out, so unless you had polyps removed, there shouldn't be any soreness. (Assuming of course, one is prepared for the cleansing with really soft tissue paper and Tucks!).