Is getting an implant on my upper 2nd molar possible and/or worth it?

About a year ago, I had my upper 2nd molar extracted. Before the procedure, I asked my dentist about getting an implant. He seemed to dismiss it as it was not necessary. I later talked to the Endodontist who worked at the same practice. He too told me that the missing tooth did not affect my smile and that I would need a bone graft. When the procedures were done, I would be paying around $4000. I can afford the procedures without too much hassle. I seem eligible, but my dentist says I shouldn't.