The best advice you have gotten here is to check with your extension agent, state forester or whatever.
If you are planting these trees where you can treat them as landscape trees, i.e., where you can tend them, water them, etc., then some of the imports may do the job. But if it's a plant and forget situation where the trees are on their own, I suggest looking at what grows naturally in your area, as they are more likely to survive and do well. The Forest Service did a test in Washington a hundred years ago, planting species from all over the world and the native species did better than any of the imports. Modern hybrids may be different.
For a good screen, look at shade tolerant trees. They develop denser crowns that will be harder to see through. Generally, they don't grow as fast as shade intolerant trees, however.
So you could go with a mix of 2 species, one shade tolerant to provide a dense screen and the other intolerant to get somewhat of a screen quickly. Spruces, cedars, hemlocks are usually tolerant while pines are usually intolerant, although actual species vary.
I'm not familiar with species in your area, but you might look at jack pine for an intolerant, fast growing tree. I understand it is similar to lodgepole pine, which I have worked with and is fast growing when young, but doesn't get real large. At the same time interplant hemlock, cedar or spruce for a dense screen.
I doubt that Douglas-fir, which actually is a fast growing tree, would do well there--DF's are very genetically adapted to the site in which they have evolved. In 1912 the Forest Service planted some at 3000 ft. elevation from seed that came from 300 feet. Didn't do well. You don't move DF very far north or south or up or down. BTW, they also planted Austrian pine in the same area and it's hard to find a single surviving pine.
Sitka spruce grows on the coast in the Pacific northwest up into Alaska, always near the coast where temps are mild. If I remember my geography right, Michigan is a little far from the mild coast. If you want spruce, use something that grows on sites similar to yours.
Drive around you area and see what does the job.