L. -
I had a tubal done in February 2002, and have had no problems since (emotional or physical). I would recommend it if you are serious about not wanting to have more children. If you are unsure about whether you want more children, I would recommend other options (ie birth control pills, iud's, birth control implants, etc) - as a tubal ligation is expensive to have reversed to my understanding.
One thing that I was asked when I had the procedure was did I want the ends "carterized" (which means they burn the ends after they tie them off). I chose to have this done as I am not looking to have any more children - and wanted to be more "sure" that the procedure would prevent that. I was also told that there is less than a 1% chance that you can still get pregnant even after having your tubes tied, so that is something else you may want to consider.
But all in all - I would recommend the procedure if you are positive that you are done having children. Nothing negative to "report" from me on the procedure. I had mine done laproscopically on a Thursday or Friday and was back to work on Monday with no major side effects and no real limitations.
Good luck!