A makeup setting spray is honestly a lifesaver! I used to struggle with constant shine too, until I tried a fixing spray. The thing is, it works all day long and doesn't dry out your skin if you pick the right one - something with glycerin or hyaluronate in it. You just spray it after your foundation, and your coverage stays way more stable. Plus, your face looks matte but not tight.
A good combo is spray plus blotting sheets for those urgent moments. By the way, blotting sheets come in different types too: regular mattifying papers made from compressed cellulose, or special ones with minerals - those don't mess up your makeup as much and even help kind of smooth it back into place! The key thing is to blot, not rub.
One more tip from my own experience: apply a mattifying primer before your foundation, specifically for problem areas (nose, forehead, chin). Once I started doing that - the combo of primer plus setting spray gave me way better staying power! The shine doesn't completely disappear, but it becomes way less noticeable, and I can go through the whole day without constantly stressing about checking the mirror.