Some heavy rail (train, subway, overground) systems are great. It depends quite a bit on the surrounding cityscape and culture though. Same goes for light rail (tram) and bus rapid transit systems although the requirements are more lax.