Local transit?.. Sure the S and U bahns are (rather) fine, but the alternative are regular roads at regular speed - the highways in such areas are speed limited (e.g. Cologne / Dusseldorf etc.). The real Autobahn is only far outside the urban area where there is no local transit whatsoever
Traveling by train ... is it some sarcasm or you've never been to Germany?