Narcissus' excessive self-love and inability to love others led to his tragic end. He became enamored with his reflection and couldn't tear himself away, eventually transforming into a flower.