During the day, yes (but be smart about it). You can catch the Q Line (light rail) from the station.
As for nearby sights, you have the Motown Museum, Fisher Building, Wayne State University's campus, Detroit History Museum, Detroit Institute of Arts, and some other museums.
Parts of Detroit...