The effects of 3d transition metal doping in TiO2 phases have been simulated in detail. The results of modelling indicate that Mn has the biggest potential among 3d transition metals, for the reduction of energy gap and the introduction of effective intermediate bands to allow multi-band optical absorption. On the basis of theoretical formulation, we have incorporated considerable amount of Mn in nano-crystalline TiO2 materials. Mn doped samples demonstrate significant red shift in the optical absorption edge, with a secondary absorption edge corresponding to theoretically predicted intermediate bands/states. The gigantic red shift achievable in Mn-doped TiO2 is expected to extend the useful TiO2 functionalities well beyond the UV threshold via the optical absorption of both visible and infrared photon irradiance.