I think I'd laugh my ass off if the Lions took Leinart.
Given their track record on QBs over the past decade or so (Harrington, Charlie Batch, etc.) it would probably mean that Leinart would fail for some reason, such as a shitty line or all his receivers getting hurt / suspended / vaginitis.