I am truly not up to date on railfaning spots.*
I don't think you can see most loading areas for the autos anymore. I recall a driver I knew (RIP last month) mentioning that.
I really only railfanned switching on the 75 Rouge bridge or the DT&I Flatrock tracks as a kid. Offhand I'm not even sure what road that was anymore, lol.
The steel mill hot car switchers still run in Rouge and they have to take cold steel out across Jefferson. Last I saw they had new blue paint and was told "robotic" or remote operated (?) Wyandotte is mostly automated now too I think.
I live a few hundred yards off the GT line paralleling 94 so I just walk the dog there on occasion. *Three or four long blocks, and thats about my physical limits the last 10 years; injury (training "Puppi" to sit for bells then go home .....hopefully. It will be my third success if he gets loose and it works. At 140lbs I use him to get up to a stand at times)
CN? I didn't either till I talked with an ho guy waiting on the CP. He had his club jacket on, so I knew whom I wanted to hang out near 
