Nanoporous silica solids can offer opportunities for hosting photocatalytic components such as various tetra-coordinated transition metal ions to form systems referred to as “single-site photocatalysts”. Under UV/visible-light irradiation, they form charge transfer excited states, which exhibit a localized charge separation and thus behave differently from those of bulk semiconductor photocatalysts exemplified by TiO2. This account presents an overview of the design of advanced functional materials based on the unique photo-excited mechanisms of single-site photocatalysts. Firstly, the incorporation of single-site photocatalysts within transparent porous silica films will be introduced, which exhibit not only unique photocatalytic properties, but also high surface hydrophilicity with self-cleaning and antifogging applications. Secondary, photo-assisted deposition (PAD) of metal precursors on single-site photocatalysts opens up a new route to prepare nanoparticles. Thirdly, visible light sensitive photocatalysts with single and/or binary oxides moieties can be prepared so as to use solar light, the ideal energy source.