I had one done many years ago that was REAL uncomfortable. I got so upset & angry that the dentist called for backup from another room.
I've had a few since then, & they were about as painless as I could imagine. So I guess techniques have improved. Good luck.