I haven't played SimCity since version 1, but in those days I thought it unrealistically penalised any city without a huge rail network.

But I think the idea of a city without roads is unrealistic, except in the case of Venice where canals take the place of roads for delivery and construction purposes.