The question is nearly always asked the wrong way round. People ask which product is better for mature skin, and the answer depends entirely on a variable nobody mentions in the question: how long you need it to last, and how closely anyone will be looking.
What separates the two is film thickness, and almost nothing else. A foundation lays down a thicker, more pigmented layer. A tinted moisturizer or skin tint lays down a thin, sheer one. Everything else that gets attributed to the two categories — the dewiness, the naturalness, the staying power — follows from that single difference.
Thickness buys coverage and costs flexibility. This is the whole trade. A thicker film hides more, and it is also less able to move with a face that is moving constantly. Over 50 there is more surface texture for a thick film to break across, and less oil underneath to keep it pliable, so the same foundation that looked immaculate at nine has visibly settled into the smile lines by two. A thin film has less to hide and much less to fracture.
Coverage is also more negotiable than people think. Most of what a mature face wants covered is not spread evenly across it — it is two or three specific things: some redness at the cheeks and nose, some pigmentation on the temples and forehead, maybe shadow under the eyes. A sheer base plus spot concealing addresses all three with a fraction of the film. Covering the whole face to fix three patches is the commonest reason a base looks heavier than it needed to be.
The tinted category is not one thing, and the names are not reliable. Tinted moisturizer, skin tint and tinted serum all describe the same basic proposition — a thin, sheer, hydrating layer with some color — and the differences between them are smaller than the differences between brands. What matters is sheer-to-light coverage and a skin-like finish, however the box is labeled. Best tinted moisturizer for mature skin covers that category on its own.
And sun protection is a real tiebreaker. Several of the thin options carry an SPF figure, and the SPF in a tinted product applied generously is closer to a usable dose than the SPF in a thin layer of foundation. If you want sun protection and color in one step, the thin categories are the ones that make sense of it.