Due to its fascinating and tunable optoelectronic properties, semiconductor nanomaterials are the best choices for multidisciplinary applications. Particularly, the use of semiconductor photocatalysts is one of the promising ways to harness solar energy for useful applications in the field of energy and environment. In recent years, metal oxide-based tailored semiconductor photocatalysts have extensively been used for photocatalytic conversion of carbon dioxide (CO2) into fuels and other useful products utilizing solar energy. This is very significant not only from renewable energy consumption but also from reducing global warming point of view. Such current research activities are promising for a better future of society. The present mini-review is focused on recent developments (2–3 years) in metal oxide semiconductor hybrid photocatalysts-based photo-electrochemical conversion of CO2 into fuels and other useful products. First, general mechanism of photo-electrochemical conversion of CO2 into fuels or other useful products has been discussed. Then, various metal oxide-based emerging hybrid photocatalysts including tailoring of their morphological, compositional, and optoelectronic properties have been discussed with emphasis on their role in enhancing photo-electrochemical efficienty. Afterwards, mechanism of their photo-electrochemical reactions and applications in CO2 conversion into fuels/other useful products have been discussed. Finally, challenges and future prospects have been discussed followed by a summary.