Detroit and its football team have long struggled. Could the city be like the Lions and roar again?