I don't know of any tours you can take of old Tiger Stadium, but check with Preservation Wayne. They do tours of Detroit landmarks and architecture, and may be able to direct you somewhere for Tiger Stadium.

http://www.preservationwayne.org/index.php

Comerica Park opens one or two hours before game time, but lots of people get there long before that to tailgate or hit a neighborhood bar.