Photoanodes consisting of titania nanotubes (TNTs) grown on transparent conductive oxides (TCO) by anodic oxidation are being widely investigated as a low-cost alternative to silicon-based materials, e.g., in solar light-harvesting applications. Intending to enhance the optical properties of those photoanodes, the modification of the surface chemistry or control of the geometrical characteristics of developed TNTs has been explored. In this review, the recent advancement in light-harvesting properties of transparent anodic TNTs formed onto TCO is summarized. The physical deposition methods such as magnetron sputtering, pulsed laser deposition and electron beam evaporation are the most reported for the deposition of Ti film onto TCO, which are subsequently anodized. A concise description of methods utilized to improve the adhesion of the deposited film and achieve TNT layers without cracks and delamination after the anodization is outlined. Then, the different models describing the formation mechanism of anodic TNTs are discussed with particular focus on the impact of the deposited Ti film thickness on the adhesion of TNTs. Finally, the effects of the modifications of both the surface chemistry and morphological features of materials on their photocatalyst and photovoltaic performances are discussed. For each section, experimental results obtained by different research groups are evoked.