> a la Trantor in Foundation, just one huge mega-city that fabricates all of its needs

If I am not mistaken, Trantor relied on an external supply chain from other planets in the empire in order to survive. It struck me as enormously brittle at the time and indeed in the books.