We don't need train stations the way we once did, but the buildings were built too nicely to not use them in some way or another. Those decommissioned stations have become homes, hotels, museums, libraries, and other facilities, and some of them are out of this world gorgeous. Shown here is the Grand Concourse restaurant in Pittsburgh. See a selection of the best at Flavorwire. Link
Of course, the size and location of the station will have a lot to do with how it can be repurposed. But I really love the ones that have been turned into living spaces. :)