The mythical creature that inspires fear due to its horrifying appearance is the Chimera. In Greek mythology, it is depicted as a fire-breathing beast with the parts of a lion, goat, and snake. Its terrifying form symbolizes chaotic and uncontrollable nature, making it a fearsome adversary in heroic tales.