We actually won out over a few options when initially hiring him.
I think he's wife was most likely the decisive factor, Cindy Horcoff is a Michigan native and i believe both of them went to Michigan State University. Anyway they lived in Edmonton, Dallas and Anaheim when Shawn was playing but when he retired, i would say that the wife said "now we go home".
I remember Horcoff spending his off-seasons in Michigan and that there was trade rumours because of it. So after all maybe Detroit was really the only option.
But i don't believe that Horcoff is in the hot seat and his resume is quite good. Lenghty hockey career and BA in finance and mathematics. On the surface sounds like a guy many would like to hire.
And this season is Horcoff's 2nd full season as a GM and as a assistant GM. If Yzerman ain't happy in the future, i don't believe that Horcoff is getting fired. They just change his role, like they did with Fischer.