I've used this product for about 30 years
http://www.belray.com/bel-ray-super-clean-chain-lube. It's great.
I tried Chain-L for a year, it lasts a long time, but it is very tacky. That means it attracts dirt and will blacken everything it touches. Chain gets noisy in cold weather.
Used Ice Wax for a while, it's the kind of lube best suited for wet weather, but since we've been in a drought for three years, I don't ride through low water crossings with water over them anymore.
I've started using Purple Extreme
http://www.purpleextreme.com/ on my Houston bike (it was developed in Houston BTW), it's amazing how much it has quieted the chain. The chain needs to be completely degreased before applying for best results, and it is applied the day before the ride. The chain no longer attracts dog fur, sand, or sling gunk.
My Hill Country bike has begun a diet of Park Tool CL-1
http://www.parktool.com/product/synthetic-blend-chain-lube-with-ptfe-cl-1 on a new chain. It is another day-before lube. Like Purple Extreme, it keeps the chain relatively clean, despite occasional rides on bare road base (crushed rock & caliche), and the usual gravel jaunt. The rear spokes and rim are lube splatter free now. The rear skin walls are indelibly Chain-L tattooed.
So in summary, for San Antonio, my recommendation is Park CL-1 for its simplicity, and Purple Extreme if you're willing to do the prep.