Whats the best everyday makeup for flawless-looking skin?

i don't know if this is common or not, but i have oily and dry skin at the same time. i have hyperhydrosis (which sucks) , so i was thinking maybe thats the reason for my oily skin.. but anyway i hate getting up close to anybody because of my foundation... like i feel like its caked on, even though it isnt. i am always blowing my money on products (cleansers mostly) that never work. i dont want to do that with makup. i want to be sure. please help! to put it in a nutshell, im looking for foundation that wont even look like im wearing any