I had mine done back in June (I think). I, too, had heard about all the wonderful extra stimulation ... but found it not to be true in my case.
I do not notice when it is in. I guess maybe it doesn't rest squarely on my clit, so while walking around, I do not feel it at all like *they* say you will. :rollseyes
When I got it done, it hurt for a split second ... like a shot in a very sensitive and previously un-pricked location. lol It was NO big deal at all. I had gotten my belly button done the month previous, and the pain was a little sharper with the clit hood, but subsided faster.
Unlike Mrs. GT, I did not have any discomfort at all immediately after getting pierced. I could wear clothes (including underwear and jeans) normally. My jeans are relaxed fit, but fit me rather snugly around the butt and groin. They aren't painted on by any means, but they are just not those hip hugger baggy leg variety that are so popular nowadays. What I am saying is that wearing these jeans immediately after the piercing, wearing pantyhose to work, wearing underwear all the time did not cause me the least bit of discomfort.
However, I have found, like Mrs. GT, that it gets in the way during sex more than enhancing it. I still have mine, though when I want my husband to get a little rough, I take it out. I learned to do that because during one of our rougher sessions, the top of the barbell went down through the top hole and I had to force it back through. Consider that the top of the barbell is a ball and the piercing hole should be no wider than the actual bar and you can surmise that I had some rippage to allow that ball to go through.
Didn't hurt a bit (maybe it would have if we weren't already in the midst of rather rough sex ... lol). It seems to have healed up because the ball doesn't just go through it on its own.
If you like your clit play to be a little rough, I would reconsider even getting it. Otherwise, if you like it more gentle, then I say go for it. Like I said, I have to take it out for the rough stuff. Most of our play partners aren't that rough and it doesn't get in the way, but it doesn't provide much additional stimulation at all. I keep mine simply for the "different" factor and aesthetic purposes. Guys seem to really like it. My husband likes the way it looks, but I think he was getting pretty annoyed with it during sex because he felt like he had to be careful all the time. I kept telling him that he didn't, but he didn't want to risk ripping me or hurting me in any way. That's why I decided to start taking it out most of the time.