Is a dermatological exfoliation treatment okay when my makeup cakes?

Even if I spend a lot of time meticulously applying base makeup in the morning, after just an hour, the sides of my nose and around my chin become patchy and white, making me look messy and stressed.
I tried scrubbing hard at home using a granular scrub, but my skin just turned bright red, and it didn't solve the fundamental issue of my foundation caking at all.
So, I decided to take this opportunity to visit a dermatologist in person and properly receive a professional exfoliation treatment that gently dissolves old impurities and sebum without irritation.
I hear that exfoliation programs are very popular these days because they use a specialized solution to gently soften sebum and dead skin cells without any physical friction from the hands, and then suction them out with a machine.
I am very curious if it is safe for someone like me with very thin, sensitive skin that easily turns red due to temperature changes to receive this kind of dermatological exfoliation treatment without breaking out.
If you pay the fee and receive a refreshing treatment just once, can you immediately see the pleasant effect in the mirror—that your skin texture becomes smooth as it is thoroughly cleansed deep within your pores?
I really want to verify if the reviews claiming that foundation or cushion adheres perfectly to the skin like a peeled egg without caking when applying makeup the next day after the procedure are actually true.
I absolutely want to completely escape this dreadful state of having skin that feels tight and dry on the inside and rough on the outside, and undergo a complete transformation into clear, transparent, and glowing skin.
If you could recommend a good clinic and a skilled doctor who can gently and moisturize to restore my disrupted skin turnover cycle to normal, I will book an appointment tomorrow and rush over immediately.
If you know of any gentle home peeling products that I can use at home, it would be a huge help to me if you could share some information in the comments so I can use them in conjunction with dermatological treatments.