Are “x10 engineers” engineers are myth or reality? And why?

Agile Software Development is tremendously popular and is seen as a universal virtue by many. It also clearly has value. But is it really a silver bullet or perhaps there are situations where it is unfit for purpose?