The percentage of water, choice of fats, choice of thickener, choice of emulsifier all interrelate. If you use one recipe except to vary the amount of water, it's been my experience that -- More water = lighter feeling lotion. Less water = heavier or thicker lotion.
Whether a lotion feels thin and watery versus lighter and creamy isn't just about the water content. This skin feel will also depend on your choice of thickener and emulsifier as well as the amount of water.
Based on my experience with the lotions I make (your lotions might perform differently), a lotion with 65% water is probably going to be pretty thick and harder to spread, so better for spot treatment, not covering large areas of skin. At 75% it's going to be like a moderately thick hand lotion -- fine for hands and body and for winter use. At 85% the lotion will be creamy and more spreadable, nicer for face and for summertime use. At 90%, the lotion will be pretty light bodied, more like a "milk" for facial use or a light summer lotion.
Fats that are solid at room temperature tend to act as thickeners and fats that are liquid at room temp tend to make the lotion more flowable. You can certainly modify the thickness by your choice of fats, but that has to be tempered by the skin feel of the fats -- some fats are greasy and heavy feeling on the skin and others are lighter and more absorptive on the skin.
I don't think I'd advise choosing certain fats only for their thickening power if you want to make a lotion that feels right on your skin. Once I choose a blend of fats I like on my skin, I will alter the water content, type and amount of thickener (examples: cetyl alcohol, stearic acid), and sometimes the amount and type of emulsifier to get the texture I want.