Metal-organic framework (MOF) catalysts are highly adjustable platforms for converting CO2 into valuable chemicals, especially formic acid (HCOOH), which is a promising liquid organic hydrogen carrier (LOHC) for safe and efficient energy storage. In this work, density functional theory (DFT) calculations at the M06-2X/6-31G(d)/LANL2DZ level were used to study CO2 hydrogenation to HCOOH over PCN-250(Fe) clusters with Frustrated Lewis pair (FLP) sites created by linker removal. The entire reaction pathway, including H2 absorption, H2 dissociation, and HCOOH formation, was mapped out, with HCOOH formation identified as the rate-determining step. To improve catalytic performance, auxiliary secondary metal substitution (M) at the Fe2MO node was systematically investigated using first-row (Mn, Co, Ni, Cu, Zn) and second-row (Tc, Ru, Rh, Pd, Ag, Cd) transition metals. Mechanistic analysis shows electronic effects primarily govern activation barriers for first-row metals, while steric effects are more impactful for second-row metals within the MOF structure. Finally, kinetic volcano plots based on the Gibbs free energy of key intermediates highlight Cu(II), Ru(III), and Tc(II) as the most promising secondary metals for efficient CO2 utilization. These insights offer a rational, bottom-up approach for designing defect-engineered Fe-based MOFs for sustainable fuel production.