I've been going to the dentist about every 6 months since I was old enough for it to do any good. I do not see it as an unpleasant experience, because I like getting my checkup and it doesn't hurt.
It doesn't surprise me that you don't like going, Gilda. Between the upbringing regarding it as frivilous, and everyone in the office ragging on you for not having regular checkups which made you uncomfortable, it makes sense you wouldn't like going.
Dentists are pretty naggy, if that's a word. Lots of people take their teeth for granted and don't see the results of that until it's too late. I would have been more firm with them when they started repeating the "bad on you for not getting checkups", but I know that isn't in your personality.
Honestly, a lot of the good vs. bad experiences seem to be with different offices\dentists. Like all professions, some are good, and some aren't.