I have one implant- lower left side 3rd to last. Because of the location, the look of the tooth is somewhat irrelevant. Nevertheless, I had to have a bone graft...wait six months...get the implant (screw)...wait six or so months.... then finally get the cap.
I am really happy with it. It is way smaller than the other big molars in my mouth due to the small space they had to put it in, but it serves its purpose. My only complaint is how expensive it is. And I couldn't imagine it being one of my front teeth~ that would be a lot harder to deal with~ cosmetically.
My parents both have implants and they are satisfied. Though my mom lost some feeling on the side they put it in. It happens unfortunately- if they cut a nerve. She is pretty unhappy about that. I would say out of all the procedures you can have done, an implant is a pretty standard, safe, satisfying one.