Cavaliers are so small it's not unreasonable to imagine they feel the chip a bit more than larger breeds.But in the overall scheme of things chipping is low on the discomfort scale when compared for example to tail docking.
I've never had a dog that's scared of the vet, but then, sometimes I think owners make their dogs scared by coddling them when they whine at the office.