I get the hope. But Goff has been on a playoff caliber team since his 2nd year in the league. Detroit is trying to rebuild. Apples to oranges. Goff has nothing around him in Detroit like he had in LA.
And no size of a chip on his shoulder is going to stop the turnovers from not feeling the rush and fumbling. Perhaps the INTs can be lessened (some of those INTs weren't his fault, but that's the case with most QBs INT stats).
I wish him the best. But it would have to be one heck of a turnaround to meet the expectations Holmes seems to be setting for him. And, in an interview, Holmes says straight out that if a QB they liked had been there when they picked, they would have taken him. Not a very big vote of confidence.