Far from the tin cans you find in the supermarket, Tin Oxide is mostly used when dealing with so-called effect pigments, tricky composite pigments that can do color travel (change color depending on the viewing angle) or give multiple color effect.
It's often found alongside Mica (as a base material) and Titanium Dioxide (as a coating) to give a glossy, pearlescent effect. Together, they make up a trademarked technology called RonaFlair Blanace from the German manufacturer Merck. According to their info, this combination can balance out undesirable tones in the skin, making it a popular choice for brightening products and highlighters.
Other than that, CosIng (the official EU INCI database) lists its uses as being a bulking agent (to increase the volume of products), as well as a physical exfoliant or an opacifying agent, but being part of composite effect pigments is a much more common use case.