I thjink I can offer a somewhat unique perspective.
I had it done when I was 18.
First, I had too much skin removed and had painful erections for about 6 months until the pink skin stretched out.
I lost a LOT of sensitivity. Before, just exposing the glans to the air felt arousing. I remember that during an exam afterwards, the doctor manipulated the glans with a gloved hand and I swear I felt absolutely nothing at all.
The tip of the penis often catches against my underwear and that is very uncomfortable.
Sex is OK, but with a condom on, I basically have to be in the right mood, or it just won't work since I can't feel a damn thing.
Climax can be a bit painful, but after all these years, it's not something I notice much anymore.
I do remember that the glans stayed quite sensitive for a coupe of weeks after the operation, and I've heard that wearing a condom or something to cover the tip constatntly will restore sensitivity in a couple of weeks. Must try it...
I tried to restore my foreskin through stretching, but since I've been so tightly cut, it didn't work, although it does feel a lot better that the skin isn't so tight now.
What else? I was left with a scar which is painful even now, 12 years later.
No woman I have ever been with (since the GF I had when I was 18) really cared wether I was cut or not.
Before the operation I never had any of the problems that I've heard about. I never had any UT infection. Actually, the first infection I ever had was afterwards. Never had the head 'caught' outside the foreskin. Never caught the foreskin in my zipper.
I did feel 'different' though. The only pornography I had seen up to that point was american, and all the men were circ'd. Though, I never felt that I was too different that my peers.
Summary: I regret having it done, but it is not a complete tragedy, since sex is not the biggest part of my life anyway.