Lucy was microchipped when she was spayed so I don't know if she knew too much about it! It has caused her no problems and has given us enormous piece of mind.
I used to work in the RSPCA cats and dogs home in Bristol and ALL dogs and cats that were brought in were microchipped. I was with many when they were done and the reactions were no worse than with a normal injection in my experience!