Exclusive photoproduction at the Tevatron and LHC within the dipole picture