Should I take an extra but "short" recommendation from a bigshot?
I think he used short as a euphemism for generic. A short letter might still be excellent if it talks about very specific things and is to the point.

If the collaboration was intense during those 2 weeks, he might have useful things to say. More probably though, he warned you politely that his letter would be generic since he doesn't know you well enough.