I think it’s more that a lot of people only think of badly done makeup and see well done makeup as natural beauty, which it enhances rather than contrasting with

Of course someone with clown-face-adjacent levels of makeup is going to look worse, but if done to make the skin look natural but smoother, eyes look natural but bigger and features natural but better defined then yes, I think very few people will find that less attractive