I had one last year, and it was fine, very uneventful actually - they had me come in on a specific day of my cycle and the procedure was quick. Pain wise, it was a little crampy but nothing I couldn't handle (after a ruptured ectopic though, your perspective on pain changes quite a bit).
I'm glad I had it done because it was a good way to rule out yet another barrier to our problems conceiving. I only have one fallopian tube left, but now we can confidently say a blocked tube isn't our problem. If that makes sense.