Refraction in exoplanet atmospheres: Photometric signatures, implications for transmission spectroscopy, and search in Kepler data