I dont like MACs foundation sorry, but I have been hearing a lot of good
reviews for their Natural MSF powders and their new loose powders.
I think as long as your face isnt dry, as long as its moisturized, powder foundation shouldnt look powdery on you. Dont put too too much on and it shouldnt look cakey. The more you "buff" it in with a good brush the more it should become "one" with your skin and it ends up looking more natural than liquid or creams, but still gives nice coverage.
I also find its quicker and easier to apply than the other types.
And I know some people like to set powder foundation with a spritz of Fix+ or some other setting spray that is a little wet, they say that takes the powdery look away as well. But personally I think as long as my skin is moisturized and as long as I buff my powder in, my foundation never ends up looking powdery.