I've had two. They were a breeze. In and out in 45 minutes, no discomfort, not a big deal. But sure, the prep is a little annoying.
"Little" annoying? God, having your rectum just spewing out urine-like shit as if it were a water tap is absolutely awful. I can't imagine doing that and then having a tube going up your damaged ass without anesthesia
I was under general anaesthetic for mine. But also smart phones and bidet toilet seat made the prep no problem as well.
They use Midazolam in Australia, which is great as it's very sedating and causes anterograde amnesia, so you don't remember a thing.