We live in a place where many people get sick from Lyme, and our vet recommended the vaccine. We got the first one, but haven't done the booster yet. Contrary to what I'd heard before, the vet said it's extremely effective. I was convinced when she told me that the manufacturer guarantees it to the extent that if a pet has the shots but comes down with clinical lyme, they will pay for the treatment (which can cost 5k or more). The vet said in all the thousands of dogs she's worked with, only two had to call in that guarantee--and the company paid. Having known lots of people and some pets who've developed lifelong debilitating problems from Lyme, that was compelling.
Also, the vet didn't recommend every vaccine, and that made me feel better about it. She didn't think we should get the dog flu vaccine unless we do a lot of competing, didn't need the lepto vaccine unless the dog is going to be swimming, and she didn't think bordatella was that helpful if we're not going to board the dog, but she did say we might have to do it at some point b/c it is required by some puppy classes, sports, and groomers. Cleo had a reaction to the parvo/distemper shot, so I'm inclined to be minimalist.