Brooks' famous essay "No Silver Bullet" is worth a (re-)read [0]. I still think AI and Automatic Programming will eventually change the face of software development in a bigger way than Brooks thinks possible; but I can't tell you when it will happen.
Agreed; after just now reviewing the Wikipedia article for The Mythical Man-Month [1], I was going to mention the No Silver Bullets point, which, IIRC, he added in the 25th anniversary edition of the MMM book.
[0] http://worrydream.com/refs/Brooks-NoSilverBullet.pdf