Metal-organic frameworks (MOFs) are peculiar multimodal materials that find photocatalytic applications for the decomposition of lethal molecules present in the wastewater. In this investigation, two new d10-configuration-based MOFs, [Zn2(L)(H2O)(bbi)] (1) and [Cd2(L)(bbi)] (2) (5,5-(1,4-phenylenebis(methyleneoxy)diisophthalic acid (H2L) and 1,1'-(1,4-butanediyl)bis(imidazole) (bbi)), have been synthesized and characterized. The MOF 1 displayed a (4,6)-connected (3.43.52)(32.44.52.66.7) network topology, while 2 had a (3,10)-connected network with a Schläfli symbol of (410.511.622.72)(43)2. These MOFs have been employed as photocatalysts to photodegrade nitrophenolic compounds, especially p-nitrophenol (PNP). The photocatalysis studies reveal that 1 displayed relatively better photocatalytic performance than 2. Further, the photocatalytic efficacy of 1 has been assessed by altering the initial PNP concentration and photocatalyst dosage, which suggest that at 80 ppm PNP concentration and at its 50 mg concentration the MOF 1 can photo-decompose around 90.01% of PNP in 50 min. Further, radical scavenging experiments reveal that holes present over 1 and ·OH radicals collectively catalyze the photodecomposition of PNP. In addition, utilizing density of states (DOS) calculations and Hirshfeld surface analyses, a plausible photocatalysis mechanism for nitrophenol degradation has been postulated.