The source I gave in an earlier post has the advantage of coverage - the guides in total cover the entire continental US.
I agree that more granular guides (covering smaller areas in more detail) are desirable. The best place I know to start is various state agencies (unfortunately these have different names in each state.)
For Michigan, the Michigan Natural Features Inventory publishes 'abstracts' for for 50+ communities. Characteristic plants (based on climate, soils and moisture) are associated with insects and vertebrates.
Local nature centers are also a valuable resource.