Quick answerMostly hype
No. Intact collagen in a cream is too large to penetrate living skin. It can moisturize the surface. For the look of firmness, look at signal peptides, retinoids and daily sunscreen instead.
If you want topical peptides with better rationale, start with copper peptides or a multi-peptide serum.