Unfortunately you won't see any engines in AC paint anymore. The AC was absorbed by the Wisconsin Central in 1995, and all their engines became WC engines. Now CN owns the WC and by extension the AC. I was up in 2004 and mostly saw CN engines (including a GMD1 doing yard duties). A WC SD45 made a showing on the freight train from the US.
There's a Quality Inn directly across the street from the station, I think there was a second one almost beside it as well. A Holiday Inn is also nearby the station and shopping mall.
There's also a shortline railroad, the Huron Central, which runs between Sault Ste Marie and Sudbury, over the former CPR branch line. It's one freight/day each direction but I don't know the schedule.