DH just had it done 3 weeks ago.
He said the shot was the worst part and hurt. The rest was fine.
He had it done on a Thursday, took off Friday and just hid upstairs from the kids for those 2 days. He was still a little sore through Monday/Tuesday, but was fine after that. We had sex for the first time (sorry if TMI) after a full week.
As far as activity goes, he was back in the mix of things as of Saturday and didn't need to use pain meds after the first day. It's not debilitating, the just feel like they got kicked down there for a few days. The urologist came and talked to me and said to make sure that he didn't lift anything over 25lbs for a week, and to take it easy the following day. That was it. Procedure took 30 minutes.