Given it's location (which was a mistake in the first place, and a mistake realized very soon after its opening), it's not nor could it ever be a hub for a local transit system short of new rail intrastructure being built to and from it, which isn't going to happen. Realistically, with a little vision, it could certainly be a commuter rail and Amtrak hub (as it once was), but local leaders decided back earlier in the decade that the hub of any transit system would be at the existing Amtrak site up in New Center because of existence of existing rail infrastructure.
I'm just happy that the talk a year or two ago of tearing the place down has been completely squashed. While it is sad to see it continue to sit and rot, the introduction of the movie industry to Michigan has actually put the most positive light on this property in years. I'm not at all worried about it standing empty too much longer. Too much
positive attention is on it now, and too many (organized) regular citizens paying attention, for its demolition to ever be politically feasible, anymore.