I got it done a year ago, and have no regrets at all! Go for it. The whole thing from sign in to sign out was less than an hour. Bring your iPod and listen to Pink Floyd's The Dark Side of the Moon or something like that to mellow out.
The nurse taped my penis to my shoulder, so it was out of the way.
I got no valium, and was able to drive myself home. Mrs. Limegrass69 was there for moral support. I was so nervous that there was an outline of my body in sweat on the paper over the exam table when I got up!
Mrs. Limegrass69 said I looked white as a ghost when I walked out, but after standing up for a minute or two, and a glass of water, I was fine.
They load you up with a local, and if you happen to feel anything, just tell the doc and he loads you up with more. They can tie you off in any one of a number of ways (my doc cauterized it). The smell of the burning flesh is a little weird.
You need to take it easy for a while (obviously). Take it easy with the exercise for a few weeks (i.e. no running). I wore bicycle pants for about a week to support the boys, and I was out and about in about 24 hours. Obviously the area is tender for a while, and keeping it iced up the first night is key. I took the perscribed percocet for the first night, and then I didn't really need it.
As long as the little incisions heal, you probably won't need a follow up visit to the Urologist. You should get a semen analysis before have unprotected sex. You will want to verify that you are, in fact, shooting blanks.