Mixed-metal−organic frameworks (MMOFs) have emerged as promising photocatalyst candidates in multiple reactions. For instance, the doping of Zr-UiO-type MOFs with Ce atoms increases their photoactivity owing to a better overlap between the organic linker and Ce orbitals. However, it is not clear which is the ideal content of Ce to reach the optimal photocatalytic performance. Herein, a series of MMOFs isostructural to UiO-66 and with napthalene-2,6-dicarboxylate (NDC) as a linker were synthesized and characterized. The Ce content was varied from 0 to 100% and their corresponding structural, chemical, photodynamic, and photoresponse properties were investigated. Powder X-ray diffraction shows that when the content of Ce is 12% onward, in addition to the UiO-type structure, a second crystalline structure is cosynthesized (NDC-Ce). Steady-state and femtosecond (fs) to millisecond (ms) spectroscopy studies reveal the existence of two competing processes: a linker excimer formation and an ultrafast ligand-to-cluster charge transfer (LCCT) phenomenon from the organic linker to Zr/Ce metal clusters. The ultrafast (fs-regime) LCCT process leads to the formation of long-lived charge-separated states, which are more efficiently photoproduced when the content of Ce reaches 9%, suggesting that the related material would show the highest photoactivity. Photoaction spectroscopic measurements corroborate that the sample with 9% of Ce exhibits the maximum photocatalytic efficiency, which is reflected in a 20% increment in overall water splitting efficiency compared with the monometallic Zr-based MOF. The current study demonstrates the relationship between the photodynamical properties of the MMOFs and their photocatalytic performance, providing new findings and opening new ways for improving the design of new MOFs with enhanced photocatalytic activities.