Can snapping your fingers excessively cause pain?

Sure. It can cause joint laxity thus leading to risk for injury or cause irritation or strain to the joint capsule and surrounding ligaments that attach to the area.