This was always a battle when I was relaxed and wore my hair down. Any product that moisturized my hair all day long was always too wet or oily. I finally settled on Allways Oil Moisturizer Lotion. If I put it on at night and tied my hair down, my hair was nice and soft in the morning. In the morning I applied a little Hot 6 or Wonder 8 Oil to my ends. I also liked ORS Carrot Oil Cream.
A friend of mine swears by Physique Spiral Cream.