For the person who came to my site googling for “What do trains look like nowadays,” I refer you to the the photo galleries at cleanairbus.com “train” tag on Flickr.
Update: Sadly, cleanairbus.com is gone, and with it the photos of trains. Flickr’s “train” tag will have to do for now.