Biomedical Potential of Tailored TiO2 Nanocomposites: Mechanistic Insights and Advanced Applications