I think you're overestimating Bowman's influence and underestimating the strength of the Blackhawks' roster. Bowman didn't join Chicago's office until after they had acquired Toews, Kane, Keith, and developed a solid supporting cast to help out these generational talents. I'm sure when his son wants his advice on something, Scotty is happy to help him out, but I hardly think that the Blackhawks' success is a result of Scotty Bowman's mastermind. I think a more accurate scenario is that he's just going along for the ride.
Yzerman also inherited some franchise pieces in Stamkos and Hedman. And if we're looking for reasons why the Blackhawks and Tampa made it to the finals and the Wings didn't, I think the first place you have to look is at the core of these teams. As I alluded to, Yzerman's core is in their prime and wouldn't be possible without having those high draft picks. Chicago's core is in their prime and wouldn't be possible without having high draft picks. The Wings' core is aging, and is entirely a product of later picks in the draft. The supporting cast is there for the Wings, but the core isn't what it used to be. Bringing Yzerman or Bowman or Nill back to Detroit won't change that scenario. They aren't going to magically bring in players of Toews' and Hedman's calibre, not without the Wings suffering an epic collapse for a few years in a row. After all, that's how Chicago and Tampa Bay got their elite talent.