You don't need to add "the" in "at sight of...". However, "at the sight of..." is OK too. "My eyes" has the same meaning as "My God", "My Jesus", something that is unbelievable to the eyes.