This is my take on it, Melissa: mammograms are not my idea of a good time, and they can be painful. But they're not nearly as painful as cancer would be.
A mammogram revealed my cancer a number of years ago. (If it were more recently, it would have discovered the cancer more easily because the technology has so improved. But I'm still glad it's long ago.) I had no family history of breast cancer or any previous problems. I went in for one of those nasty, pesky mammograms, and a very sharp radiologist looked at the pictures and thought, "That one doesn't look like cancer, really, but it doesn't look quite right." So I had to go back and get some more pictures (ouch), and then a needle biopsy - still inconclusive - and finally a surgical biopsy, which discovered a very small amount of very early cancer. We took care of that thing, and then I had even more frequent pictures taken for a number of years.
Since then, I don't mind how often I go in or how uncomfortable it is, as long as they do a good, thorough job.
A mammogram can detect a cancer the size of a pinhead or smaller. It can see cancers you can't possibly notice when you check yourself. This is a very, very good thing.
There's some controversy right now over the age when women should begin to have regular mammograms. But if your doctor thinks you should have one, go ahead. Expect to hurt, but not for long. I always have an excellent, friendly technician! I let her maneuver me into the right "pose," stand very still, close my eyes, and start counting (in my head). Before I get to ten it's done. The soreness is annoying but it doesn't last long. Frankly, the "squashing" isn't nearly as bad as the fear about it!