> Is there anywhere in the world where the train system is 'really good' for a majority of people?
I think Switzerland comes pretty close to this. Granted, I was only a tourist, but was really nice seeing how you could take a train from Geneva to any of the towns bordering Lake Geneva almost all night long, at pretty good intervals. And they were always on time, at the minute.
What happens is that development happens around train/subway stops.
You can see this right now around the Washington DC area, where cities and sky rises have been popping up over the last 30 years, centered around individual metro stops.
You build the rail first, and the city builds around that.
So it follows that the US doesn't have a 'good' passenger train system because there is not such thing.