This isn't a movie or TV show, and the "Trains in video games" topic seems to be missing as searching for the words "Trains video games" brought up nothing of that topic.
The game Fallout 3 has a Monorail System, Subway system, and an old Rail system through out the Capital Wasteland. None of them are able to operate since the game is set in a post nuclear wasteland.
Most of the Monorails tracks are destroyed or the monorail trains have derailed in some places.
The Subway tunnels are collapsing and oddly enough there is always a stopped subway train almost every few yards. Seriously the Subway system had no signaling system obviously. I mean there are So many trains in the same tunnel. I have seen cases where there are 3-4 on the same track just a few feet from each other.
The Railroad is far and few between. Most of it has been recovered by nature of was bombed. A few sites still exist through the whole waste land. The only cars you find for this are boxcars. All the boxcars are red also which is very odd considering how many there are.
"The Pitt": A Fallout 3 expansion that takes place in a destroyed Pittsburgh. How do you get there from Washington D.C? A Handcar of course in an old Railroad tunnel. Arriving outside of " The Pitt" you find a shocker, Yellow Boxcars. The normal red are still there,but the yellow stand out and remind you that this is a whole different place.
In The Pitt you also have to go through an old Steelyard next to the Steel Mill. the yard is littered with boxcars filling up three tracks side by side. Once again the yellow and red make up the consists.
Randomly through The Pitt you will noticed old Trolley lines in the streets. No trolleys are in game but there are enough bus ruins around the lines. My thought is that Bethesda did this as to not make a new Model for the trolleys that would of ran those lines and just fool you by using bus ruins.
That is all I know about trains games,movies, or TV shows as of now. All others I know have already been stated.