I've got the palest Irish freckly skin going - I find MAC really good (but make sure to go to the counter and ask the experts) or just wear a tinted moisturiser.
I have been accused of being translucent so I feel your pain. The absolute best foundation I have found is Clinique. Their Super Balanced foundation makes my skin look great.
but sometimes i do buy the wrong kind, and instead of wasting money i usually I damp my sponge with water and it makes the foundation blend a bit better with my skin.