Biological Applications of Thiocarbohydrazones and Their Metal Complexes: A Perspective Review