I usually wear my twists for a week to a week and a half...I don't use gel to twist, I just don't like gel in my hair. I have experimented with lots of different "stuff" to get my twists/twistouts just right. I have used:
1. plain shea butter(melted) - good product for twists, as long as you don't use too much, a little on the finger while twisting will do fine, using too much will cause a film to build up on the hair
2. shea butter, melted, w/ a few drops of e.o.(lavender or rosemary)- the e.o. "cuts" the shea a little better and it spreads easier
3. mango butter(melted) - comparable to shea, no difference
4. Kemi shea butter pomade - I love this on wet and dry twists! Again, a little is all you need and I love the candy smell, smells just like the oil
5. Carols Daughter Healthy Hair Butter - Another product I am in love with for twists, "herby" smell, spreads PERFECTLY on wet or dry twists...have purchased about 4 times since going natural 2 years ago. Will purchase again but always with a friend, the s/h is too high.
6. Avocado Butter - purchased this after a suggestion from an internet buddy, I like the texture, very easily spreadable, a lil more "greasy" than any of the stuff above but price is good(5.25 for 4oz at fromnaturewithlove.com), will purchase again.
So as you can see, I have used alot of stuff and NONE of it has disappointed me. As you can also see, nothing above is a gel or water based product. My twists stay smooth and moisturized after about 3 or 4 days until I want to moisturize again. The only spray I have found locally that I like to spritz my hair with is DNL Citrus Braid Spray or I will take a shower with no cap on. Other than that, I rub avocado butter throughout my twists and castor oil on the ends if my hair starts to feel dry. For the twistout, I don't spray anything in it. After a week/week and a half of all of the above, my twistout last for about 3 or 4 days and I do not sleep in a cap. I only sleep on a satin pillowcase. I can't keep anything on my head while I sleep. HTH!