This is something I struggle with too! I see all these people on the internet wearing full coverage foundations and looking flawless - but I think it’s important to consider the amazing lighting set ups people have to make their foundation look great. Personally, I find that when I wear really full coverage foundations, it makes my skin look mask-like or really dry and textured.
I find a good way around this is to use a foundation that suits the level of coverage you feel you want on the best areas of your skin - for example, my forehead usually behaves pretty well and I only need a light coverage, so I stick with a lighter coverage foundation. Then I’ll use a high coverage concealer to focus on the areas that need attention, as I find this leaves me with a healthier skin look overall. Then I’ll skip powder and use a setting spray to avoid adding additional layers. Here’s some of the products I use: