In the past decades, various photocatalysts such as TiO2, transition-metal-oxide moieties within cavities and frameworks, or metal complexes have attracted considerable attention in light-excited catalytic processes. Owing to high surface areas, transparency to UV and visible light as well as easily modified surfaces, mesoporous silica-based materials have been widely used as excellent hosts for designing efficient photocatalytic systems under the background of environmental remediation and solar-energy utilization. This Minireview mainly focuses on the surface-chemistry engineering of TiO2/mesoporous silica photocatalytic systems and fabrication of binary oxides and nanocatalysts in mesoporous single-site-photocatalyst frameworks. Recently, metallic nanostructures with localized surface plasmon resonance (LSPR) have been widely studied in catalytic applications harvesting light irradiation. Accordingly, silver and gold nanostructures confined in mesoporous silica and their corresponding catalytic activity enhanced by the LSPR effect will be introduced. In addition, the integration of metal complexes within mesoporous silica materials for the construction of functional inorganic–organic supramolecular photocatalysts will be briefly described.