It seemed like Andy's eyes were opened on more than one occasion........usually when he was too hard on Opie or misjudged the little fella. Several times he expressed his "faith in Opie" after he had doubted or blamed him. Overall, Andy's eyes were usually clear and steady. Just now and then he was in the dark.
Aunt Bee had more than her share of eye opening moments in the series. I can think of several. She was all the time getting the wool pulled over her eyes. I would like to mention the time she roused the female population of Mayberry to stand up for Mr. Frisbee's property when he was being evicted by the county so that highway could join up. That is until she realized that his egg operation was a front for his moonshine still. Then the ladies turned on him like bears backed into a beehive.
Andy got his eyes opened (and one closed) the first time he met Skippy and Daphne at the restaurant out on the county line when he and Peggy were fighting. "Why don't you go feed your hungry buzzard!"
in Bailey's Bad Boy, Bill Bixby's eyes are opened to learning to stand on your own two legs.
Opie's eyes were opened when he took that sling shot and killed that mother bird. Barney went and showed him how to be an expert marksman with a sling shot. Bad move Barn!