I've found it! After a month of shopping for foundation, I've settled on Shu Uemura Face Architect. The criteria was (1) doesn't look like i have makeup on. (2) natural and not ghosty on my yellow-tone skin, (2) doesn't make my dry flaky skin looks worse than it already is.
To my surprise, the 964 fits perfectly on my dry& flaky Asian skin with uneven skin tone. It reduces my red blotches, and give a smooth flawless yet natural look. I never wear any makeup except for special occasions. But with this, I could wear it everyday!
I've owned both shiseido powder foundation and Mac select(NC37) foundation. Both of them makes my dry skin flakes badly as soon as I apply them. Also, the best matched color on Mac and Shiseido still makes me looks like either like a ghost, or too dark.
I'm happy I found Shu Uemura. Now I'm wearing it everyday! It makes me look less tired and have better skin. Even though I do not use any concealer, it covers my dark circle rather well.
I've tried Laura Mercier Tinted Moisturizer in nude & sand. Sand was too dark on me, and nude is rather similiar to 964. After a week of using both(one of each side of the face), shu uemura stands out. It lasts longer than Laura Mercier's, and has better coverage if layered on.