Redness is the one complexion concern where the physics genuinely favor makeup. Red and green sit opposite each other on the color wheel, so a thin green or yellow film cancels a proportion of the red light reflecting off the skin. That is a real optical effect, not a marketing claim, and it is why color correction works when almost nothing else in a makeup bag does what it says.
The problem is dosage. Most people apply color corrector like concealer — a visible layer, pressed in — and the result is a gray-green cast that looks worse than the redness did, because you have now over-canceled and dulled the skin. The correct amount is a sheer veil you can barely see. Thin, over the red area only, and then a normal foundation on top at normal coverage.
The second consideration is triggers, and this is where the page has to be careful. Rosacea is a medical condition, this is a makeup site, and nothing here is medical advice. What can be said as a product-design observation is that heat and friction are widely reported triggers, that mineral sun filters work by sitting on the surface while some chemical filters convert UV to heat, and that a formula requiring vigorous buffing involves more friction than one you can press on. Those are reasons to prefer certain formats. They are not a treatment plan.
Fragrance comes off the list first here, as it does on the sensitive skin page, and for the same reason: a thinner mature barrier lets more of it through.